HI, What is the easiest workflow to do a simple left outer join? I have a data table : IDCODE1a2a3b4b5b6c7d8e a look up table : CODEValueaXYZbDEFeKJL And I require the following output : IDCODEValue1aXYZ2aXYZ3bDEF4bDEF5bDEF6c 7d 8eKJL Can anyone advise please? Many thanks!

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

HI,

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

I have a data table :

a look up table :

And I require the following output :

Can anyone advise please?

Many thanks!

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

Best,

MSalvage

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

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

Best,

MSalvage

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

thanks @MSalvage, works perfectly