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



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


1 Like


try to rename the column with the value in dt1


Check with this xaml,

GetRowFromDataTableUsingIndex.xaml (7.8 KB)