I have extracted the different format invoices data. All the fields data (like invoice no, invoice date .etc )is in one Data table ex.DT1 and all the invoice table data (like description, qty, price) is in another data table.
for example DT1 and DT2 is like this
DT1
DT2
I want save the all extracted data in one sheet.
This is just a example I have multiple invoices.
In the for each loop it is extracting the data and creating DT1 and DT2.
If I use merge activity for DT1 and DT2 getting output like this.
This solution may be work when all invoices extracted fields are same.
In my scenario Invoices are different and column data of each invoice is vary from another,
So I am saving the data in different sheet if invoices having same format then next invoice data append to that sheet.
tried this way , successfully able to extract desired format in excel, just need to provide different sheet for each invoice.
But , I want output like , if same invoice format comes , data output of corresponding invoices shall come in next row , Using your suggestion , it is over writing the previous invoice data.( same Format).