Forum Discussion

arcegabriel's avatar
arcegabriel
Icon for Helper I rankHelper I
5 years ago
Solved

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 concaten...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    arcegabriel -

    To accomplish like:

    Add Column

    Custom =
Record.ToList([[Column1],[Column2]])

    Add another Column

    Custom.1 =
List.Sort([Custom])

    Extract Values from Custom.1

     

     

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

arcegabriel -

To accomplish like:

Add Column

Custom =
Record.ToList([[Column1],[Column2]])

Add another Column

Custom.1 =
List.Sort([Custom])

Extract Values from Custom.1

 

 

arcegabriel's avatar
arcegabriel
Icon for Helper I rankHelper I
5 years ago

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