cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BODS - Data exporting in incorrect order (.csv file)

radhika_sharma3
Explorer
0 Kudos

We have an ETL batch job that loads data from a database table into a CSV file. The first column in the CSV file is a key column. Although all the values are exported successfully, the key values are not sorted in the CSV file. 

 

#SAP BODS

#Data Services

SAP Data Services 

View Entire Topic
Julian_Riegel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Have you included an order by Key Column in a query advancing your output?

BR

Julian

radhika_sharma3
Explorer
0 Kudos
Missed including the column in ORDER BY tab.