Forum Discussion
Which row will keep Table.Distinct(Table, {"Column"})
Hi colleagues, Which row will keep Table.Distinct(Table, {"Column"}) for the rows with the same values in the "Column": First row? Last row? Random row? MS documentation has no explanation abo...
that's interesting, thank you.
At the end I used this
https://www.youtube.com/watch?v=hidJ5T_DYQ0
works like a charm
but I jsut noticed that in the notes she added a second better method, which I didn't have the time to try yet
Hello,
Just to notice that using grouping might lead to a huge computation time. Furthermore, if you want to keep only one row, using Max as the aggregation function might not work if there are multiple rows with the max value. Therefore you may think to use Table.FirstN as an aggregation function: same issue, it would burst your memory.
Therefore I think using Table.Buffer is the best idea when it comes to sorting
Best