Removing duplicate data

[odalistt]

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. 

[v-juanli-msft · Accepted solution]

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

[Anonymous]

Go to Edit Queries

Select the Remove Rows dropdown on the Home tab

Select Remove Duplicates