community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

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!

Highlighted

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

 

2019-03-11_15-36-46.jpg

Labels