Forum Discussion
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
- AnonymousNot applicable
Go to Edit Queries
Select the Remove Rows dropdown on the Home tab
Select Remove Duplicates
- v-juanli-msftCommunity 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