I need to retrieve this specific columns with their expected data values from SOQL resultset when I execute the following SOQL query
select SI_Old_Product_ID__c , Name, (Select Name ,SKU_MAP_Price_Amt__c from SKUs__r) from SI_Product__c WHERE CreatedDate > 2013-10-08T01:02:03Z
[Sample Data from the query above when executed][1
How can I optimize the data coming from a subquery so that it can appear in its respective columns like
Name SKU_MAP_Price_Amt_c 200696-01 19.99
I am using the Sales force input step in Pentaho.
Please help me.