How to Compare two datatables and write only unique values in first datatable

[LB34]

@raghuramk

I need to Compare two excels excel1 and excel2 and write the unique values in excel1 to excel3.Please r

Hi,

See if the solution here helps, it worked for me

How to remove duplicates in merge data table to get unique values?

Hi All, I am merging to data table, 1 data table is from early this morning with data in it, I have another newer data table I just scraped both have same column names There is a good chance they will have the same data plus more in the newer data table I can merge both tables, however I want to remove all duplicates, not just 1 set of duplicates All I want to be left with is rows that had no duplicates. Is there a way to do that? I tried 'remove duplicate rows, which it did, just not th…