Forum Discussion
MasterSonic
Helper IV
Helper IVText.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],"|")),"|...
I got it:
= Table.AddColumn(#"Added Custom2", "NewColumnName", each if [ExisitngColumnName] <> null then Text.Combine(List.Sort(Text.Split([ExisitngColumnName],"|")),"|") else "Empty Cell")
amitchandak
Super User
Super UserMasterSonic , use List.RemoveNulls
Table.AddColumn(#"Added Custom2", "NewColumnName", each Text.Combine(List.Sort(List.RemoveNulls(Text.Split([ExisitngColumnName],"|"))),"|"))
https://docs.microsoft.com/en-us/powerquery-m/list-removenulls
MasterSonicHelper IV
Helper IVI still have this:
Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]
Any Idea?