Forum Discussion
Solved
Table.Combine : How to handle null values?
Hi all! I want to merge ALL columns except the first one on the depicted table. The column count is dynamic. There maybe more than these. I'm using the code : = Table.CombineColumns(T...
A post in an other thread helped me to find my own solution.
Instead of Merging the columns at once, I added a custom column first that uses Text.Combine and at the same time removing NULLs, like that :
AddedCustom = Table.AddColumn(Source , "Merged", (row) => Text.Combine( List.RemoveNulls(List.Skip(Record.FieldValues(row),1)), " / " )),
The community here is very helpful! :smileyvery-happy:
A post in an other thread helped me to find my own solution.
Instead of Merging the columns at once, I added a custom column first that uses Text.Combine and at the same time removing NULLs, like that :
AddedCustom = Table.AddColumn(Source , "Merged", (row) => Text.Combine( List.RemoveNulls(List.Skip(Record.FieldValues(row),1)), " / " )),
The community here is very helpful! :smileyvery-happy:
Nice. I didn't know about that function.
