Alteryx Designer Desktop Discussions

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

An Easier Way to Use Left Outer Join Using the Join Tool

RonGatmaitan
8 - Asteroid

Hello,

 

I just noticed that, when trying to implement a "left outer join" on data using the Join tool, I still have to use the Union tool to combine the data from the left (L) and join (J) outputs. Then I have to address those warning messages that some fields from the join are not present in all inputs.

 

Is there an easier way to do this wherein data for both are actually combined already?

 

This is not the case when using the Join In-DB tool.

2 REPLIES 2
apathetichell
19 - Altair

You can set the Union tool to not give you those messages (Ignore when Fields are different). There is no automatic way to do an Outer Join (Left/Right/Full) with the (conventional) Join tool. You have to combine it with the Union tool.

RonGatmaitan
8 - Asteroid

Thank you, @apathetichell. 🙂

Labels