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 because every week I will be adding new files with new data but sometimes that data can be repeated, how can I remove this duplicate data?

 

 For example, this is my table 2 which contains new values:

Table 2

This is my table 1 which contains these data, the same data exists in the table 2, when I created the append relationship, my report show duplicate information, how can remove the duplicate data (from the table 2)?:

 

 table 1

Thanks. 

  • 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Go to Edit Queries

    Select the Remove Rows dropdown on the Home tab

    Select Remove Duplicates

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    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