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!
Solved! Go to 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.
Hello,
This idea suggests a coalesce function :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Coalesce-function/idi-p/841014
Best regards,
Simon