Formula to Combine 4 columns containing blanks

Question

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!

KT TOC.yxmd

KP_DML · Accepted Answer

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/m-p/18817/highlight/true#M8412