Formula to Combine 4 columns containing blanks

[a460659]

Hello,

I have 4 Name columns i'd like to combine into 1 new Title Column. 

I'm trying to output so that if Name4 has data then Title is Name 4, but if Name4 is blank then Title is Name3 and so on. I can't get the Formula to work so that the Title field doesn't contain any null/blanks.

Topic Title = IF Isnull([Name4]) THEN [Name3] ELSEIF Isnull([Name3]) THEN [Name2] ELSEIF Isnull([Name2]) THEN [Name1] ELSE [Name4] ENDIF

Any suggestions on a different approach would be appreciated, thanks!

[KP_DML · Accepted solution]

Hello,

Alteryx does not have a built-in COALESCE function, but you can use conditions like @JohnJPS did in the thread linked below. You would want to change the order of the fields for your situation.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Function-similar-to-quot-Coalesce-quot...

[simonaubert_bd]

Hello,

This idea suggests a coalesce function :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Coalesce-function/idi-p/841014

Best regards,

Simon