How to copy a row from one table and paste it on another table on another table

I have two data tables, one contains a single row and other contains some data. I want to add that single row from first data table on top of the second data table and make it as headers.
I guess i can merge them both using Merge data table activity, But I didn’t understand how to make them headers. If there is another way than merge activity, please let me know.
In the following way
dt1Capture2
dt2Capture1
FinalDtCapture

Thanks!

@Chaitanya_podilapu

take a copy of the data table one and use add row activity to add the rows from the second data table to Final dt

Regards
ajay

1 Like

@Chaitanya_podilapu

try to rename the column with the value in dt1

@Chaitanya_podilapu,

Check with this xaml,

GetRowFromDataTableUsingIndex.xaml (7.8 KB)