Forum Discussion
How to combine/concatenate columns while ignoring nulls?
I would like to combine/concatenate all the columns (while ignoring the nulls).
I've tried adding a custom column using:
[Number ID]&[Grouping 1]&[Grouping 2]&[Year]&[Quarter]
but it gives null as the result for each row.
Hi Anonymous ,
Try selecting columns and merging them. The UI lets you select the delimiter. Not sure how it works with null. But you may be able to add an if statement to that..
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
1 Reply
- Nathaniel_C
Community Champion
Hi Anonymous ,
Try selecting columns and merging them. The UI lets you select the delimiter. Not sure how it works with null. But you may be able to add an if statement to that..
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel