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...
You are forgetting that if you want to remove distinct letters that are different cases (A/a) then you need to add the optional parameter Comparer.OrdinalIgnoreCase
Table.Distinct(Table, {{“b”,Comparer.OrdinalIgnoreCase}})
This will treat A and a as duplicates. Otherwise, A/a are not the same in this function.
--Nate