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.
Challenge 4: Combining data - Tableau Tutorial
From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Merging data using unions3m 3s
-
(Locked)
Union data using wildcards3m 58s
-
(Locked)
Correcting mismatched fields3m 40s
-
(Locked)
Explaining the different join types4m 9s
-
(Locked)
Creating joins4m 8s
-
(Locked)
Correcting join errors3m 38s
-
(Locked)
Challenge 4: Combining data41s
-
(Locked)
Solution 4: Combining data3m 55s
-
(Locked)
-
-
-
-
-