Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formula to Combine 4 columns containing blanks

a460659
5 - Atom

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!

2 REPLIES 2
KP_DML
8 - Asteroid

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
13 - Pulsar

Hello,

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

Best regards,

Simon

Labels