How to copy common columns in 2 datatables to new datatable

Ex. datatable1 has following values

column1 column2 column3
1 2 3
4 5 6

datatable2 has following values

column2 column3
2 3
5 6

Both datatables may have some other columns also

I Required output as
column2 column3
2 3
5 6

Since these 2 are common columns in both datatables

Merge these two data tables into third data table and use “Remove Duplicate Rows”

@reyaz can u share workflow? if u dont mind

@Manjuts90 Here is example xaml
table.xaml (13.0 KB)

1 Like

Like the example @reyaz! Great job.

@reyaz i dont have remove duplicates activity in office system(my version 2016.2) Do u any other method for this.

Step 1. Write merged data table on excel
Step 2. Remove duplicates from excel using excel feature Data > Data Tools > Remove Duplicates.
Step 3. Read excel after removed duplicates

1 Like

How can we achieve below format, input data table is

Out put should be output