Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Simple Left Outer Join........

Highlighted
8 - Asteroid

HI,  

 

What is the easiest workflow to do a simple left outer join?

 

I have a data table :

 

IDCODE
1a
2a
3b
4b
5b
6c
7d
8e

 

a look up table :

CODEValue
aXYZ
bDEF
eKJL

 

 

And I require the following output :

IDCODEValue
1aXYZ
2aXYZ
3bDEF
4bDEF
5bDEF
6c 
7d 
8eKJL

 

Can anyone advise please?  

 

Many thanks!

 

Highlighted
8 - Asteroid

Use the Join Multiple tool and join on Code. Leave "Only Output Records that Join from All Inputs" unchecked.

Highlighted
11 - Bolide

@fiorano,

 

You can use the Join tool and join on code. Then union the L and J outputs.

 

Best,

MSalvage

Highlighted
8 - Asteroid

Hi @sjm

 

Thanks for the reply. This still only brings back records that are joined.....

 

 

Highlighted
8 - Asteroid

thanks @MSalvage,  works perfectly

Highlighted
8 - Asteroid

hey @fiorano does the attached workflow give the output you're looking for? 

Highlighted
5 - Atom

Thanks a lot.

Learnt from your example

Highlighted
7 - Meteor

Thank you so much for this! I'd thought that the "join" action would include a checkbox option to allow an outer join. This is a much more sexier solution than the join + union combo action.

Labels