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