Often string data fields contain information that you might want to split into separate fields, such as forename and surname. Using the split function Tableau Zen Master Matt Francis demonstrates how to take a string and split it into separate fields, both automatically on white space and then using any delimiter that you have.
- [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 split.…
Now if we add these to our field,…
The training starts with one of the most important features in Tableau: the difference between the green and blue pills (discrete and continuous data) and how this affects every single action Tableau performs. Then find out how to add new maps and create more effective dashboards that maximize screen real estate. Discover how actions can link together sheets and provide greater levels of interactivity and performance, and how formatting can make an ordinary dashboard demand attention. Plus, get some bonus tips on performing date and time calculations in Tableau. This course deep-dives into the practical, applicable, and essential skills that anyone doing data visualization and analytics in a professional setting needs to have.
- Green vs. blue pills
- Using filters, colors, and dates
- Connecting to data
- Extracting data
- Cleaning and prepping data
- Pivoting data
- Merging and joining data
- Highlighting data
- Using the Analytics pane
- Creating new maps
- Creating calculations based on parameters
- Designing dashboards
Skill Level Intermediate
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.