How to copy common columns in 2 datatables to new datatable

datatable

#1

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


#2

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


#3

@reyaz can u share workflow? if u dont mind


#4

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


#5

Like the example @reyaz! Great job.


#6

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


#7

@Manjuts90
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