SOLVED
Advanced Join
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AuditPro13
8 - Asteroid
‎08-01-2019
02:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!!
Solved! Go to Solution.
Labels:
- Labels:
- Join
1 REPLY 1
JosephSerpis
17 - Castor
‎08-01-2019
02:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.