i have multiple files to process.
each file is read, data is retrieved and finally loaded in the application.
I have created a data table to track the status. Say after each file is processed and an order gets created, the order number is stored in the data table. Other info like No of lines loaded, etc. Each record is created after a file is processed and loaded into the application.
I am doing Write range to create excel from that DT.
My requirement, I want to have all the orders created, say 20 files will create 20 orders. So i want the DT to have all 20 records.
Currently write range overrides and gives the latest file processed data.