Remove ALL Duplicates Entirerly

Hi Anonymous 

Let me rephrase what i understood, and then provide the solution. 

You have two data sets A and B. A has 300000 rows, B also has 300000 rows and a new set of data i.e. 50000 rows. You would like to filter the newly added records from table B. 

If my understanding is correct then below is the solution.

Import both A and B in separate queries. Now that you would like to see the remaining rows in Table B or new records in B, please select Query for table B and then follow the steps:

Select B Query --> Home --> Merge Queries / Merge Queries as New (if you want the data in a new table then select the second option) --> Select table A from the dropdown list --> Highlight the Unique ID# column in both the tables --> in the JOIN KIND select LEFT ANTI --> Click OK. 

You're sorted.

If you think this is the solution then please do mark it as a solution

Pradip Pardeshi

Microsoft Certified Trainer

Pradip's Youtube Channel