Tableau Prep Join Types Explained (All 7!)

One of the primary ways we combine multiple tables of data in Tableau Prep is with joins! Joins allow us to merge multiple tables of data horizontally on a common key.
One of the things that distinguishes joins in Tableau Prep from Tableau Desktop are all the join types we can create! In Tableau Desktop, we're limited to Left, Right, Inner and Outer joins. In Tableau Prep we have those four options with the addition of Left Unmatched, Right Matched and All Unmatched. Those unmatched join types provide greater flexibility to create customized workflows and identify values which did not match in our join clause.
Ready to learn how to harness the full power of joins in Tableau Prep? Check out this video!
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Resources:
•Example Data: data.world/ericparker/populat...
•Joins, Unions and Blends: onenumber.biz/blog-1/2018/1/1...
Chapters:
0:00 Data & Setting up Join
2:30 Interpreting Join Results
4:07 Selecting Join Types
10:55 Real-World Scenario
11:55
12:27 Cleaning Up Data Post-Join

[@onenumbertableau]

Need help with Tableau? Schedule an hour with Eric here: onenumber.biz/office-hours
Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes