Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Advanced Join

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

 

 

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor
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.
Labels
Top Solution Authors