Copy row to another data table

Hello Community Friends.,

I want to copy an entire row from first data table and paste it to second data table 2 times. Then i need to compare reference number from the original sheet and replace the duplicate one. How can i do this? Need help.

Thank you

Use Add Data Row to add a row from the first datatable to the second datatable.

can you help me with the syntax here ?

the row index would be dynamic. it is not fixed that which row to add ? that way i need the syntax

Hi @mannu.1996.08 ,

You can use it as

assuming both datatables have the same columns you can use “Add datarow”,

in this example i loop over the first datatable and copy the second row to the other datatable