community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Formula to Combine 4 columns containing blanks

Highlighted
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!

Meteor

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...

Labels