Need help in joining two or more columns and remove few values from the final column

Q&A
, , ,
1

I had a data set with 10+ columns with different field values and null values. My usecase is to merge all the 10 columns and remove null values. Can refer the screenshot for the same.

Screenshot 2024-02-20 at 11.23.25 AM
Screenshot 2024-02-20 at 11.23.25 AM1920×1200 194 KB

2

Hello @cadit,

Not sure what you mean with remove null values, e.g. when you use concat

if the value of the field is null then it will not really show, see example below.

image

image