Forum Discussion

anshpalash's avatar
anshpalash
Helper II
4 years ago
Solved

Remove Duplicates Across Multiple Tables

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 ...
Need Help
  • mattww's avatar
    mattww
    4 years ago

    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.

mattww's avatar
mattww
Responsive Resident
4 years ago

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.