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.

Solution 4: Combining data

Solution 4: Combining data - Tableau Tutorial

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

Start my 1-month free trial

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…

Contents