Forum Discussion

dudeyates's avatar
dudeyates
Frequent Visitor
7 years ago

Using Power Query and M to Delete Duplicates Based on Certain Criteria

I'm trying to figure out how to remove duplicate rows based on certain criteria. If one of the rows matches the criteria, I keep it and delete the duplicates. I can do this in VBA, but I really want ...
Need Help
dudeyates's avatar
dudeyates
Frequent Visitor
7 years ago

Thanks for the response. I'm not sure of the steps to take to get to the Asset Key you created. How does Removing Duplicates know that I want to keep tc_and_lineitem: "1083 1" with a af2 = "16700", but remove tc_and_lineitem: "1083 1" with a different af2?

 

Thanks, 

James

Aron_Moore's avatar
Aron_Moore
Solution Specialist
7 years ago

My column was a simple concatenate basically = [Column1]&[Column3]&[Column5]

 

yours will likely be more complex, don't really know with the data your showing. Instead of Remove Duplicate you may need to create some sort of key that you could then filter duplicate rows out that way.