Finding records that are not common between two tables

Question

Hi Team,

As a simple thing, I am using join tool to pick common records between two tables that are having different columns.

But, I also need to see records that are not common between both tables. So, case is:-

* I am joining two tables based on common field OrderID

* But there are some orderIDs that are not common between both tables. For instance, some OrderIDs are available in table A but not in table B and vice versa

* So, I need two different lists of data which will be:-

- From table A, orderID that are not available in table B. with such OrderIDs I also want to have other columns(from table A) as well just to check what information we have in those columns. And same information I need to have from table B

Your input will be highly appreciated.

Thank you

binu_acs · Answer

@Vikas038 The Alteryx Join tool has three outputs, L, J, and R as separate subsets of your data.  If you examine the output of the L (left), you will see the records that existed in the left data set, but do not match with records from the right.  The J (join) output provides only the records that are common between the two data sets.  And the R (right) output provides the records from the right that don't match with those on the left.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Combine-Join-Output-Anchors-with-a-Union-Tool/ta-p/596613