Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to join 2 datasets and include unique records

I'm fairly new to Alteryx and would greatly appreciate some assistance.  I need to join 2 files in order to combine 2017 and 2018 sales data.  I have tried to use the join function, but this excludes any discontinued or newly launched products (unique to one dataset).  Is there a different function I can use to also include these unique records?  I attached an example with my desired result.  Thank you!


The easiest way is to add a Union tool and then feed L,J,R into the union