Copy row to another data table

[mannu.1996.08 (Ankita)]

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

[postwick (Paul)]

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

[mannu.1996.08 (Ankita)]

can you help me with the syntax here ?

[mannu.1996.08 (Ankita)]

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

[ermanoj3101 (MANOJ)]

Hi @mannu.1996.08 ,

You can use it as

[jack.chan]

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

[AJITH_SK (S TAMILARASAN)]

Hi @supermanPunch , i need one help.

Dt1 :

Header - A B C
Value 1 2 3

Dt2 :

Header - A B C D E
Value - empty

String variable P -4
String variable Q - 5

I expected output :
Dt2 :
Header - A B C D E
Value - 1 2 3 4 5

Pls give solutions.