Hi Everyone,
I have a requirement where in need to fetch more than 20K records from the database and then store it in Excel file,
As of now we are querying all the data once and writing it into a single excel file, which is taking more than 10-15 mins.
Can anyone suggest how we can break this into multiple excel file using the process model i,e if there are 100 records in the databse then we should be able to get 10 excel file with 10-10 records in each file.
Discussion posts and replies are publicly visible
What exactly are you doing? 20K records is not that much, you should be able to use Export to Excel node to quickly export it.
What we need is to create a process model which can generate multiple excel file with a given no of records in each file.