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!
Discussion posts and replies are publicly visible
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
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?
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.
But Export SQL to Excel smart service has been deprecated and it might be removed completely in the upcoming releases. So this method might not be the correct solution.
Keerthanakr said:smart service has been deprecated and it might be removed
It's been "deprecated" officially for several years now but still works fine, and there is yet no sufficient replacement for it - so it won't be removed without plenty of advanced notice.
This pulg-in is available named as SQL to Excel smart service still existing not shown as deprecated.
Abhishek Karumuru said:This pulg-in is available named as SQL to Excel smart service
that's different from the Excel Tools plug-in which is the longstanding, widely-used one that most people are familiar with and might already have implemented processes using, for what it's worth.
May I know can this pulgin could be the solution ?