Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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)?:
Thanks.
Solved! Go to 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
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
Go to Edit Queries
Select the Remove Rows dropdown on the Home tab
Select Remove Duplicates
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |