From the course: Intro to Tableau Prep

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Value operations | Split values

Value operations | Split values - Tableau Tutorial

From the course: Intro to Tableau Prep

Start my 1-month free trial Buy for my team

Value operations | Split values

“

- [Instructor] Let's talk about split value value operations. In Tableau Prep, you're able to split text based on values on automatic or custom-defined delimiters. Splitting can be a valuable tool that can help derive new calculations and values to extract data from our fields. To split values, go to your More Options menu, choose Split Values, and then you'll have the option between Automatic and Custom Split. An automatic split will derive the split by using common delimiters. Tableau Prep will automatically decide which delimiter to split by and how many splits should be shown. If Tableau Prep doesn't get it right, you can always go ahead and do a custom split. A custom split will allow you to define the delimiter and the number of columns for the split. Now, it should be noted that if you're doing an automatic or a custom split, you're always going to get a calculation out of it. Now, you can also create a calculated split by hand, but the format will be the same. So if you're…

Contents