Forum Discussion
Concatenate values with sort in Power Query
I am trying to concatenate two strings but really my concatenation should be indifferent from the column in which they appear
What I have
a b > should concatenate as a, b
a c > should concatenate as a, c
b a > should concatenate as a, b (same as first case)
This is I really don't care about the order just the combinations. I thought I could resolve this by sorting before concatenating but can not figure out how to do that. Appreciate any assistance
Table is large so looking for something lightweight if possible
To accomplish like:
Add Column
Custom = Record.ToList([[Column1],[Column2]])Add another Column
Custom.1 = List.Sort([Custom])Extract Values from Custom.1
2 Replies
To accomplish like:
Add Column
Custom = Record.ToList([[Column1],[Column2]])Add another Column
Custom.1 = List.Sort([Custom])Extract Values from Custom.1
Thanks for your help.
In the end I used if / then and compared string 1 to string 2. I was not aware that I could compare strings to determine order.
However your method is much more scalable (longer list) so appreciate it as well
