All tagged Join

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.

A huge benefit of using joins in Tableau is that we can combine data from multiple tables into a single table for analysis. When those tables are in different databases, it can be a little tricky to work out where to start. If you know how to join tables within the same database, that's great! Cross-database joins only take a few more steps to execute, and I'll walk you through them in today's video.

How do you join two tables together in Tableau when they don’t share the same common field? Or what if that common field is slightly different in both tables? A Join Calculation can help solve a lot of those problems! In this video, we take a look at how to use a join calculation to join tables with mismatched fields.