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 3: Cleaning data

Solution 3: Cleaning data - Tableau Tutorial

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

Start my 1-month free trial

Solution 3: Cleaning data

“

- [Instructor] Here's the solution to challenge number three. So we have our airline data, and the first thing we want to tidy up is the airline description. In this particular case, we have a combination of the name of the airline and the airline code. And in order to split those into two, I need to use a custom split, because I need to tell Tableau Prep to split on the colon. There's some other characters in there, so I need to use a custom one to make sure it does it in the right way. So, we click on the drop down, split values, custom split. The separate in this case is going to be colon, and I want to split off both fields. So in this case, I'm going to select all. So the result of this is two new columns, one that is the airline name, and one that's the airline code. So I'm going to rename both of these fields. The airline, and then I'm going to rename this one to airline code. Next I'm going to do is actually clean up the values in the airline data. Now we can see that we have…

Contents