Hi Experts,
I'm extracting some data by doing some comparisons via process model and when whole data is extracted(just before the process going to end node), I finally dump the data in excel using Export CDT to excel.
But the problem is, in this process a variable of type CDT contains whole data for long (till dumping it to excel) which increase its chances of failure if a large amount of data will extract.
I want ---> If in total there are 6000 rows which need to be extract,
So I want to extract first 1000 rows and dump them in excel and repeat this process for all the 6000 rows which extract in 6 times.
Main problem ---> I want all the data in same excel, same sheet, next 1000 rows append after the first 1000 rows
Don't want different excel , different sheet.
Suggest some possible solutions thoroughly
Thanks in advance
Discussion posts and replies are publicly visible
Hi harshw0876,We cannot do it as you want because after running the smart service(Export CDT to Excel) once, it returns the document and this service has also been deprecated.instead of this, you can use the Export Data Store Entity to Excel smart service, This service exports the data from the respected table.if you already have data in the table you can directly use this service with the required filters. if not then create a temporary table, map with Datastore, and insert the data in batching in a temporary table and use this temporary table entity in the smart service whose data you want to export.once data is exported, truncate or delete the inserted data.to understand more visit this Documentation:-https://docs.appian.com/suite/help/23.4/Export_To_Excel_Smart_Service.html
Hi nasirs4970 ,
Thanks for replying
I understand all the things you said but the only restriction is that I can't create any new table, not even my data is directly from DB table. The only thing I want a single excel sheet with whole data in end.
Hi harshw0876,I understand, that you have a restriction is with creating a temporary table then we can't use this smart service but this is the most appropriate approach by performance point.but if you want to continue with this deprecated smart service then you can try that generate multiple Excel documents according to your batching data and merge all the Excel documents by the merge Excel document smart service and generate a new merge Excel document. once the merge Excel document is generated, delete the Excel document generated by batching data from the system.