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.
Solution 4: Combining data - Tableau Tutorial
From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
Solution 4: Combining data
- [Instructor] Here's the solution to the union and join challenge. So, first thing we need to do, is add the week two and week three flight data into our already cleaned out data set that we've used previously. So I'm going to have to add two new connections one for each of the .csv Files. So they are text files they're in our data folder and we already have week one so I need week two and we did the same thing to bring in week three. So now I need to combine week two and week three together using a union. Now we've already cleaned up week one, so I want to make sure that union step happens after our clean step. So let's add a union, then we can drag our week two file to join that union and our week three file in as well. So now we can bring the pane up and we can see we've got some mismatches. Now where we did our clean up step we had our airline and our airline code but in our other files that's referred to as carrier or unique carrier so we need to combine those together. So I'm…
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)
-
-
-
-
-