How to perform Outer Join and Non-Intersect join?

Question

Hello,

I need to perform the Outer Join for the following data.

Output is the one highlighted in Green. I used the join and the union condition to achieve the same, but wanted to get an expert's opinion on that.

And I also need to perform the non-intersect join.(image attached)

ANy help would be appreciated.

Thanks!

2022-07-25_23-01-26.png

ChrisTX · Accepted Answer

For the same output, you could use the Append tool, then the Unique tool

For non-intersect join:  if you only want Left or Right non-intersects, look at the L or R output anchors.  For both Left and Right non-intersects, feed the L and R Join output anchors into a Union tool.  The optionally use a Unique tool.

A good learning resource is under Learn > Academy > Learning Paths

Chris