Advanced Join

[AuditPro13]

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

[JosephSerpis · Accepted solution]

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.