Forum Discussion
purple_SP
Helper I
Helper IFinding duplicate lists where the values are in different orders
Hello, I am working with some data in the following type of format where column 3 is a list of values: Column 1 Column 2 Column 3 John Smith A,B Sarah Jones B,C Jane Wo...
NewStep=Table.Distinct(Table.TransformColumns(PreviousStepName,{"Column 3",each Text.Combine(List.Sort(Text.Split(_,",")),",")}))
wdx223_Daniel
Community Champion
Community ChampionNewStep=Table.Distinct(Table.TransformColumns(PreviousStepName,{"Column 3",each Text.Combine(List.Sort(Text.Split(_,",")),",")}))