Efficient way to convert the data rows to excel without using List to CSV mapping step
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?
Comments
-
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
Howdy, Stranger!
Categories
- 4.4K All Categories
- 79 General
- 13 Training
- 209 Installation / Setup
- 1.1K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 709 Forms
- 345 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 186 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 229 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions