Exporting to excel

Question

Hi Everyone, 
 Can anyone suggest me if I need to export DSE to excel which have more than 50 columns, which smart service to prefer. Since Export DSE to excel smart service works for only 50 columns. 
 Thank you!

Mathieu Drouin · Answer

I have never tried this but perhaps you could try 2 exports (i.e. columns 1-50 and columns 50-100) and then merge using the Merge Excel Documents in the Excel Tools plugin? 
 community.appian.com/.../excel-tools

Mike Schmitt · Answer

I know there are a wide range of use cases, but please be sure to at some point at least consider whether "more than 50" is too many to be usable to anyone , which will usually be the case. 
 Also i believe you can just call the node a second time, pointing to the result of the first use, and pointing at a starting cell one column to the right of the final column generated by the first call. Does this not work for you?

Abhishek Karumuru · Answer

Hi Rahul009 the better way is to use export sql to excel smart service this can be used for large amount of data as well. use select query for the required columns in sql parameter in that smart service.