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

[Alex_DerKetz]

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

[Jan_Brian_Despi]

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

How to merge two data tables

hi To merge two data tables I’m using merge data table. I have to merge table1(2rows and 4 colums) with table2(1row 1column) but the output is like it is passing null values upto table1 rows in table1 and appending new rows of table2 in table1. finally table1 has(3row 5columns) instead of the i need table1 with 2rows and 4columns

Thanks and regards,
Despi

[Lahiru.Fernando]

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)

[varunk (Varun Kumar)]

Hi @Alex_DerKetz,

Use select for mapping two excels