Forum Discussion
Removing duplicates first vs last, power query is alternating???
Hello all, I have a question about eliminating duplicates using excel power query. I'm pulling data from a folder that I routinely put new CSVs into. There's almost always duplicate transactions ...
KNP
Super User
Super UserProbably need to see some data and/or the query code.
Specifically, how you are doing the duplicate removal.
Stab in the dark guess, if you're using a Table.Sort followed by a Table.Distinct anywhere. Make sure you add a Table.Buffer immediately BEFORE the Table.Distinct.
It forces the sort order to be maintained.