Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

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