Alteryx Design Pattern: Filtering and Outer Joins

Use Case:

This is what we call a BOGO friends. If you want to know how to use a Join to filter records this works but also I always get questions about how does someone do something other than an inner join…this is how. Hopefully you can see how you would do a Left Outer Join as well as a Full Outer Join!

Steps:

1. Input Data
2. Item list to be used as filter
3. Join on item (ie Product)
4. Union with “J” first, then “L” or “R” depending on the join you want