cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
odalistt Frequent Visitor
Frequent Visitor

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:

table1.JPGTable 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)?:

 

 table2.JPGtable 1

Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Removing duplicate data

Hi @odalistt

In Edit Queries, after appending,

Add a column to merge all columns into one column

 

2.png

 

Then remove duplicates

3.png

 

Then you could remove the merged column without reflecting the table

4.png

 

Best Regards

Maggie

2 REPLIES 2
kgmccann Regular Visitor
Regular Visitor

Re: Removing duplicate data

Go to Edit Queries

Select the Remove Rows dropdown on the Home tab

Select Remove Duplicates

Community Support Team
Community Support Team

Re: Removing duplicate data

Hi @odalistt

In Edit Queries, after appending,

Add a column to merge all columns into one column

 

2.png

 

Then remove duplicates

3.png

 

Then you could remove the merged column without reflecting the table

4.png

 

Best Regards

Maggie