Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago
Solved

Text.Combine skip nulls

Hi Guys, I am adding column and sorting values within cell values with |  : = Table.AddColumn(#"Added Custom2", "NewColumnName", each Text.Combine(List.Sort(Text.Split([ExisitngColumnName],"|")),"|...
  • MasterSonic's avatar
    MasterSonic
    4 years ago

    I got it:

     

    = Table.AddColumn(#"Added Custom2", "NewColumnName", each if [ExisitngColumnName] <> null then Text.Combine(List.Sort(Text.Split([ExisitngColumnName],"|")),"|") else "Empty Cell")

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago

I got it:

 

= Table.AddColumn(#"Added Custom2", "NewColumnName", each if [ExisitngColumnName] <> null then Text.Combine(List.Sort(Text.Split([ExisitngColumnName],"|")),"|") else "Empty Cell")