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.

Splitting fields into new ones

Splitting fields into new ones - Tableau Tutorial

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

Start my 1-month free trial

Splitting fields into new ones

“

- One of the first steps that we might want to do when we start cleaning our data is to split some of the fields into component parts. To show an example of this, I'm going to look at the sample superstore xls file, which you can find in the data folder. So we've made a connection to the Excel and I've pulled in the orders table. And I've added a clean step so we can actually look at the data. Now, if you've used Tableau Desktop, this should look very familiar to you as it's the same sample superstore data set that you used for your training there. Now, in this example, we have a number of columns. We have our row ID, order ID, order date, everything that should be familiar with you. And one of the things that we want to do is look at the order ID. And we see here that it's quite a long field. We have what looks like maybe a product ID in there, some customer information, maybe, and possibly a date field. But it's all combined into a single string. Now what I want to be able to do is…

Contents