From the course: Tableau 10 for Data Scientists

Unlock the full course today

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

Split fields

Split fields - Tableau Tutorial

From the course: Tableau 10 for Data Scientists

Start my 1-month free trial

Split fields

- [Narrator] One of the common things that we need to do with our data is to split text into different sections. Let's take a look at an example. I'm connected to the acrossthebay10k sheet, which you can find in your Exercise folder. These are the race results of a 10k run, and we have about 15,000 runs in here. If we look at, say, the Name field we have the full name. Now we might want to split this into forename and surname. An easy way of doing this is to use the split function that Tableau has. To do that, all we do is right click on the Name and then Transform and Split. Now the default way to split is on white space. So, we go ahead and do that. And now we have two files Split 1, Split 2. Now note the change and new icon. We have the little equal sign. This indicates that this is the result of a calculation. And in fact we can go down and edit this and see the calculation that Tableau has done. So behind the scenes, Tableau has actually done a calculation and the result is the…

Contents