Merge datatable based on column

Hi All,

I wanted to merge two datatable based on name shown below

table 1
id name number
1 x 56
2 y 26
table 2
company name number pnr dv
xxx x 56 s45 q56
yyy d 56 s94 t526

o/p:
table 3:
id name number pnr dv
1 x 56 s45 q56
2 y 26

@ranjani

Use Merge Datatable activity to merge two data table based on the column name.
Destination as Table 1 and Source as Table 2
and used Filter Datatable to remove the column.
Hope this will help you

Thanks
Suresh J

that didnt work for me …i already tried .The column arrangements are different

@ranjani

In filter Datatable in column filter, you can rearrange the column as per requirement.
Mention the column in order you want.
Hope this will help you
Thanks,
Suresh J

for me to merge table should the table have same schema?

@ranjani

No need the same Schema, it will merge data based on the column name, I will share the sample for the same.
Thanks,
Suresh J

Please help

@ranjani

Please find the working file for the same sample you have been given,
Sequence.xaml (10.0 KB)
Hope this will help you.
Thanks,
Suresh J