From the course: Tableau 10 Essential Training

Unlock the full course today

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

Splitting text into multiple columns

Splitting text into multiple columns - Tableau Tutorial

From the course: Tableau 10 Essential Training

Start my 1-month free trial

Splitting text into multiple columns

“

- [Narrator] Well structured data collections divide information into discrete units. You should store information about customers and their orders in separate tables, for example. And you should also split 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. I'll show you how to do that in this movie. I've started Tableau and I'm at the start screen so I can create a connection to an Excel file. To create that connection I'll go over to the Connect panel and click Excel, and then in the chapter two folder of the exercise files collection I'm going to double click the Excel file SplitData. Doing so creates a connection and you can see that the data has already been imported and I can see it down here. If I increase the size of the Product Combined column, you can see that I have two different…

Contents