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

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Using the data interpreter

Using the data interpreter - Tableau Tutorial

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

Start my 1-month free trial

Using the data interpreter

“

- [Instructor] Sometimes, when you open up your data file in Prep, it doesn't always read it correctly. Let's see how to fix that with a data interpreter. So, I'm going to connect to a file in the Exercise folder. It's an Excel sheet called Active Duty Marital Status- Air Force and Army. We open that up, and Prep identifies that there are two sheets, Air Force and Army. So let's bring Air Force in, track it over into the pane, and we can see the field names that it's tried to identify. And these don't look quite right. These look a bit odd. We've got F1, and a lot of null values. So what's going on there? If we open up this file in Excel, we can see that the format of this has actually been created in order to make a nice looking report. We've got a lot of padding. We've got this header up here. We have a subheader, and we have this information about what the data's showing us. We have some merged fields, and generally, this has been formatted to look good when somebody's reading…

Contents