What is the best way to mapp data from one DT to another

Hello, a have two DataTables
for example
FirstDT has next columns (Name_1, Surname_1, email_1,…)
and SecondDT (Name_2, Surname_2, email_2,…)
i have a mapping dictionary.
So, what is the best way to copy data from first dt to second?
Thank you

Hi @Alex_DerKetz,
You can use Merge Data Table activity.
You can also refer to this topic by @vvaidya:

Thanks and regards,

Hi @Alex_DerKetz

Check out the workflow attached. This gets data from multiple excel files as datatables and merges them into one single data table and writes back to excel. I think this will suit your requirement.

merge datatable.xaml (9.8 KB)

Hi @Alex_DerKetz,

Use select for mapping two excels