This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a join running, but on occasion, my right side of the join will have no data (null) which is causing the join (and entire workflow) to fail. I can't have that happen, as the other data in the workflow needs to run.
Is there something I can put prior to (or after) my join that will help me with this?
If I'm understanding you @parnell correctly, you have a join where the RIGHT side (could be LEFT) of the incoming data sometimes has 0, 1 or many rows. In the case where 0 rows are present, the JOIN tool fails.
If that is the correct problem, then I would recommend that you:
TEXT INPUT tool configuration with the JOIN KEY fields defined with valid TYPE of data but illogical values. If you are joining on ID and STATE as an example, make the ID -1 and the STATE ZZ. Just create 1 record in the Text Input tool so that SOMETHING will always be present.
UNION TOOL configuration with the incoming TEXT INPUT along with the NORMAL DATA. Ignore any field differences and KEEP all fields
Take the output from the Union into the RIGHT JOIN.
This way, a GARBAGE record will at minimum be present. It will NEVER join to the data.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.