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.

Challenge 4: Combining data

Challenge 4: Combining data - Tableau Tutorial

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

Start my 1-month free trial

Challenge 4: Combining data

- [Instructor] Here's a challenge using unions and joins. First, you're going to open up 05_07_Challenge, which is looking at our flight data. You're going to need to add the additional flight data for week two and week three, which you can find in the data folder. We're going to combine those using a union. Remember to add those after the initial clean step. Next, you need to fix any mismatch errors, and then remove any extra columns you don't think add to the analysis. Lastly, we want to combine the data from the Flight delays.csv file. To do that, we need to import that data and use an inner join. This should take you about five minutes.

Contents