Remove Duplicates Across Multiple Tables

[anshpalash]

Hi,

I have two separate tables that contain an ID column. The ID column in both tables should have unique values. That is, an ID in one table should not repeat in the other table.

I know how to remove duplicates from a single column in a single table. But how do I consider removing duplicates in an ID column in two different tables?

Also, how can I see how many duplicate IDs are there across the two columns in the two tables?

Any help is much appreciated. 

[mattww · Accepted solution]

Hi @anshpalash 

You could append the two tables together, creating one long table and then remove the duplicates from there. 

If you wanted to identify IDs with duplicates, use this appended table, right click on the ID column, select Group By and leave the operation as "Count Rows", this will then give you a count of how many records have that ID, so anything above 1 is a duplicate. 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.