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?
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.