From the course: Tableau Essential Training

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Split text into multiple columns

Split text into multiple columns - Tableau Tutorial

From the course: Tableau Essential Training

Start my 1-month free trial Buy for my team

Split text into multiple columns

“

- [Person] Well-structured data collections divide information into separate units. You would store information about customers and the products they order in separate tables, for example. And you should also split items like customer names into first name, middle name and last name columns when you can. If you need to work with data that combines multiple values into a single column, you can try to split the text into multiple columns to make it easier to work with, and in this movie, I will show you how to do that. I'm starting in Excel so that you can see the data we're working with, and the file is "SplitData," which is an Excel workbook you can find in the "Chapter02" folder of the exercise files collection. And here, I have a list of cities and states where my company has hotels, so I have the property ID in the first column, and then, city and state combined into the second column. However, because city and state are separate entities and cities are contained within states…

Contents