From the course: Tableau for Data Visualization

Unlock this course with a free trial

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

Splitting and combining columns

Splitting and combining columns - Tableau Tutorial

From the course: Tableau for Data Visualization

Start my 1-month free trial Buy for my team

Splitting and combining columns

“

Hello everybody, in this lesson we're going to see how we can split out this column we're picking up from our very last lesson and we want to be able to split this out to make it more usable. And so what we're going to do is we're going to come right over here, we're going to go to this drop down and we have a split and then we have a custom split. Now just for now let's create a split and let's do it just like this. You'll see that it retains the original column, but then we have pivot field names, that's what it was called. And then we have pivot field names split one, and pivot field names split two. And we can drag this over to see that. So it created these two new columns based off of this data. Now really quickly, if we come in here to custom split, you'll kind of see how this split works. First you have a separator. Now when you just split it, it's kind of just assuming it's supposed to be this space. But if it was a comma or a dash or a period or whatever it is, you can…

Contents