Efficient way to convert the data rows to excel without using List to CSV mapping step

Akira_Sainak

I'm in Decisions 8.11. I'm fetching the data from DB and using List to CSV mapping to export data to excel. With this method it's very slow with considerable data. It took around 8 minutes to export 4k+ records.

Is there an alternate way or performance efficient way to convert the data to excel?

Sumanjana_Decisions

Hey,

If you are using any step to fetch data from DB like Raw SQL, check the type of output you've selected. Click on the step, on the right side properties panel, navigate to Output Setting-> Return Output Option, by default, it will be set to Data Rows. Change that to Excel to get the output of the step in Excel format, so that you can skip the List to CSV mapping step.

If your issue needs to be further analyzed, kindly reach out to support@decisions.com