Remove columns after using merge Datatable actvity

Learning Hub
, , , ,
1

Hi everyone,

I need help to delete the columns after using merge data table.

Data Table-1

image

Data Table -2

image

Now I am using the merge Datatable activity with left join
and getting output as:

Output-DT

image

Desired Output is

image

Please Suggest me something to do this.

Thanks in Advance.

2

Remove columns can be used in the resulting Datatable.

3

updated topic.
Please recheck

4

Its Join Data table or Merge Data table?

5

Book1.xlsx (11.4 KB) Test.xaml (8.4 KB)

Please check with the Test file

6

hey,
Thanks a lot it worked.
Can you help me in doing one more step further.
for the records matched in inner join of the to data table,
I wanted to add a column named “STATUS”
if the row is in inner join the status columns is updated as valid
and for the rest of the rows it writes in valid

7

This can be tried using Linq.