Hi there,
I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file?
regards,
L
Discussion posts and replies are publicly visible
CDT to Excel found in the Excel Tools plug-in can do this (it's marked as deprecated but still works just fine AFAIK)
Appian would not recommend to use deprecated plugins, though it works fine. We had an issue in earlier working deprecated plugin. when it start failing it will be hard to get any support.
so use "Export DSE to Excel", you have to save the data into database table, then export, right? that's really inconvenient as I need to export data which comes from more than one table.
so if that's the case, I have create a new table contains all the data, and save the data into this new table, then export, right?
Abhay Dalsaniya said:Appian would not recommend to use deprecated plugins
Appian has never seen fit to provide a fully acceptable replacement for the CDT to Excel Smart Service - once they do that, they can get back to me (/half joking but half very serious). But on a more serious note, I agree, the deprecated smart services should be used with greater caution than others.
linp0001 said:I need to export data which comes from more than one table
The official Appian answer to this would likely be that you need to create a specialized View just for the use case of this export, since then you'd (presumably) be able to join data from as many different tables as you want to be included in the export. My qualms with the Export DSE to Excel Node are mostly other issues, fwiw.