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")

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi MasterSonic,

 

May I know whether your problem has been resolved? If so, could you please mark your solution by Accept it as the solution to help the other members find it more quickly. Thanks in advance!

 

Best Regards,    

Community Support Team _ Caiyun