Join tool

Question

Hi All:

Using the join tool, I noticed that the options for the ouputs are either L J R where:

* L = Data from the left table that did not join with the right table
* J = Data where both tables joined
* R = Data from right table that did not join with the left table

I there any tool or option that can get me either LJ or RJ....that is to say the whole of the left table + data from the right table that joined (LJ) ...or...th whole of the right table + data from the left table that joined (RJ).

Thanks.

-Tesh.

DataNath · Accepted Answer

You can use the 'Join Multiple' tool for that - it acts the same as a join but brings the outputs together, giving nulls if they aren't in one of sources (as seen below), resulting in an outer join. Example workflow attached.

The other option is to literally just union the unmatched records back on to the matched results (R+J outputs for a right outer, L+J outputs for a left outer etc):

binu_acs · Accepted Answer

@prpatel to connect the R+J you need to union the R-output and the J-output from the join tool same for the  L+J output