Forum Discussion
Function working with String but not with Column
Yes, I see that in the function steps, however, did you test nulls? What value and type is in Column 1? The reason I ask is because when if statements are included in functions and the function is invoked, the behavior is slightly different than it would be if included outside of the function.
What is the value and type of Column1? Are there any nulls? What happens if you pass null instead of "test test"?
It can be null and text. For null I made a special case: Combined = if text <> null then let ... else Combined = null
Yes, I see that in the function steps, however, did you test nulls? What value and type is in Column 1? The reason I ask is because when if statements are included in functions and the function is invoked, the behavior is slightly different than it would be if included outside of the function.