From the course: Tableau for Data Visualization

Unlock this course with a free trial

Join today to access over 25,900 courses taught by industry experts.

Joining on real data

Joining on real data

Hello everybody, in this lesson, we're going to be using real data to perform some joins. Now, the data that we're working with is called PayPal Payments. We have a lot of really interesting information over here. We have the ID, we have the created date, the amount that they spent, amount refunded and the currency that they used. Now, we're going to scroll over quite a bit, all the way over to the end and you'll notice we have some price ID and the product ID. This product ID will be important in just a little bit. Now we're going to go back and we have these products, so we have a products CSV that we're going to tie in here as well, because we have the product ID but we don't have the product name. So let's bring over this products CSV, we're going to drag it over right here, and you can see that we have an ID to the ID. Now this is not actually correct because this needs to be the product ID to the ID here. So this is our product's ID, it's just called something a little bit…

Contents