Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Advanced Join

8 - Asteroid

Hi Family,


I would like to know if it is possible to do the following join in Alteryx:


Join on "Field A" but if blank or NULL join on "Field B".


Thanks in advance!!! 



Alteryx Certified Partner
Alteryx Certified Partner
Hi   Could you not have formula tool and create a column then use this syntax like this If ISEMPTY(FieldA) then Field B Else FieldA  ENDIF then you join should work.