From the course: Tableau 10 for Data Scientists
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Split fields - Tableau Tutorial
From the course: Tableau 10 for Data Scientists
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.