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 ...
Thanks KNP ! That might be exactly what I'm looking for. I'll do some more research on buffering and try getting that worked into the code. Here's a snippet of the current code for my duplicate removal. All sorting at the moment is done in the table itself post query. Learning the code for sorting in the query is a next step but I'd thought it wouldn't make a difference when the sorting took place.
KNP
Super User
Super UserDefinitely don't rely on the sorting to be maintained. Make it explicit.
Something like this...
= Table.Buffer(Table.Sort(PreviousStep,{{"ColumnName", Order.Ascending}}))
Ascending/Descending and other sorting columns as required of course.