Need to use "Text Doc From Template Smart Service" for exporting more than 300 columns data from a table. Can anyone help me out how to configure this smart service and use it in PM which will give data in csv format or excel format.
Discussion posts and replies are publicly visible
Hi Amrit, Is there any specific reason you are using this smart service ? becasue using this smart service for data export, i dont think a good idea. can you tell us about your requirement little more?
Export Database to csv is having limitation of 50 columns for export that's why I want to use this smart service "Text Doc From Template" because we have requirement to export more than 300 columns.
Its not feasible to use this smart service for data export, instead you can use export data store entity excel smart service and run this node in loop and export first 50 columns and then next 50 and so on . once loop ends you can merge these generated excel files.