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)


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