@kaderms - I am expecting an output like shown in your screenshot. How can I achieve that? Did you get to see my workflow? If merge datatable doesn’t help with this, should I only be using for each to achieve this which is like kind of a lengthy way to do this.
My usecase is like, Name, Age and Job columns might differ but View column will always remain same but just repeat for every 3 rows. From excel row number 5, again the view column value would be ‘1’.
I will extract data from an web app for the columns Name, Age and Job everyday and store it in dt1 and then merge it with dt2 which only has view column.
Finally append the dt1(destination) table data to another excel sheet which has previous day records of dt1(dt1+dt2 merged)
Can you please help?