From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Explaining the different join types

Explaining the different join types - Tableau Tutorial

From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Start my 1-month free trial

Explaining the different join types

“

- [Instructor] One way that you combine data in Prep is using joins. There are three types of join, inner, left and right, and outer joins. Now there are some subtle differences between these that are going to make a big difference when you do your analysis. So to understand that, let's look at some example data. So here I have some products, in this case, fruit, and each one has an ID number, a name, and a price. I then have some sales data. So I have a customer, the ID of the fruit that they bought, and the amount of each fruit that they bought. So I want to combine both of these together, and I'm going to look at three different ways of doing that. Firstly, an inner join. Now an inner join only retrieves rows where the transaction appear in both tables. So to see what that result looks like, let's have a look. In example of the inner join, only results where the items appear in both the left and right-hand table get returned. So in this case, we can see that the apple, pear, and…

Contents