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

Unlock the full course today

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

Correcting join errors

Correcting join errors - Tableau Tutorial

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

Start my 1-month free trial

Correcting join errors

- [Instructor] It's easy to combine data in Tableau Prep using joins. We simply use dragging and dropping our fields together to combine them into a larger dataset. We can combine data from individual sheets, within the same workbook, or different workbooks spread anywhere in our system. However, what happens when a join doesn't quite work, how do we fix those errors? To show that, let's look at this flow that I've already started building. Now I've already combined the audience scores and the critic scores from some of Steven Spielberg's films. I've then cleaned those and I've then brought in the budgetary information. So far my data looks like this, I have the year, the film, the audience score and the critic score, and some information about the budget. Now I've been asked to add in the box office information. So this exists in my file over here and I can bring that in, and I can now combine this with the rest of my dataset. Now I want to apply this after the very final clean step,…

Contents