Forum Discussion

odalistt's avatar
odalistt
Regular Visitor
7 years ago
Solved

Removing duplicate data

I have 2 equal tables, the second has the same data as the first and also some new records. How can I delete the duplicate data that appears in both tables?   I created an append relationship becau...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi odalistt

    In Edit Queries, after appending,

    Add a column to merge all columns into one column

     

     

    Then remove duplicates

     

    Then you could remove the merged column without reflecting the table

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi odalistt

In Edit Queries, after appending,

Add a column to merge all columns into one column

 

 

Then remove duplicates

 

Then you could remove the merged column without reflecting the table

 

Best Regards

Maggie