How to copy common columns in 2 datatables to new datatable

Learn Academy Feedback
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)

1 Like
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

1 Like
8

How can we achieve below format, input data table is
input

Out put should be output