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	1621	January 7, 2019
How to remove duplicates in merge data table to get unique values? Help datatable , studio , question	11	8278	December 21, 2020
How to merge two excel sheets when we have few items common between them Help	10	1601	April 17, 2019
Merge two datatables with common column Help	5	11085	October 29, 2018
Join two datatables with no common column Help datatable , excel , uiautomation , studio	3	4295	October 29, 2018