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
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.
You can use Custom Cell Positions and Custom Cell Values parameters for the upper part (Id, Status, Created By, etc) in the sheet.
Then, define the cell (for the bottom part) from where the service will start writing data using the 'Starting Cell' parameter.