Alteryx Design Pattern: Filtering and Outer Joins
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!
- Input Data
- Item list to be used as filter
- Join on item (ie Product)
- Union with “J” first, then “L” or “R” depending on the join you want