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

[fiorano]

HI,  

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

I have a data table :

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

a look up table :

CODE	Value
a	XYZ
b	DEF
e	KJL

And I require the following output :

ID	CODE	Value
1	a	XYZ
2	a	XYZ
3	b	DEF
4	b	DEF
5	b	DEF
6	c
7	d
8	e	KJL

Can anyone advise please?  

Many thanks!

[sjm]

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

[MSalvage · Accepted solution]

@fiorano,

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

Best,

MSalvage

[fiorano]

Hi @sjm

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

[fiorano]

thanks @MSalvage,  works perfectly

[sjm]

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

[Willey_dup_372]

Thanks a lot.

Learnt from your example 🙂

[MatthieuArzel]

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.