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 the way I thought it would.
Any Assistance is greatly appreciated
Fred, John, Sam
I want to merge both DT1 and DT2 (this works fine), however then remove duplicates, so all I have is