Forum Discussion
Solved
Composing text with null values replaced by nothing
I'm trying to compose a text (to define the location of a file) that is made of the combination of Drilled down values (concatenated with "&") The problem I face is that there are instances when som...
Text.Combine function can ignore the null value in its first parameter.
Hey there. You can do this:
NewStep = Table.AddColumn(PriorStepName, "NewColumnName", each if [Column2] = null then [Column1] else [Column1]&[Column2], type text)
---Nate