I have 2 excel sheets with different datarows in it.There is one coloum common to both tables but it has redundant values.I need to produce output in third data table as per below from both tables.Common values from both table should be listed once.Can anyone explain logic for below? dt1 …

How to merge two datatable and list common and uncommon values?

ppr (Peter Preuss) March 25, 2021, 7:17pm 6

1 Like

Compare Two column of different excel file on it's uncommon item

Topic		Replies	Views
How to copy common columns in 2 datatables to new datatable Academy Feedback datatable	7	1565	January 7, 2019
How to remove duplicates in merge data table to get unique values? Help datatable , studio , question	11	7239	December 21, 2020
How to merge two excel sheets when we have few items common between them Help	10	1525	April 17, 2019
Merge two datatables with common column Help	5	10846	October 29, 2018
Join two datatables with no common column Help datatable , excel , uiautomation , studio	3	4137	October 29, 2018