The Split function in Tableau.

The Split function allows you to use a delimiter to split out text inside of a calculation. Tableau can also automatically do this for you but in this video, I show you how it creates the calculation for you and how you can customise it to split out text the way you like.

-
Join this channel to get access to perks:
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

[saydeeztee]

Hi Tim. I need to split using comma; however, there are instances of text (with double quotation text qualifiers) that contain a comma within the text object. How would you handle that split? Example: {"Name":"John Smith, Jr.", "Age":6, "Weight":45, "Hometown":"Pleasantville"} --John Smith, Jr. should remain in one column (and not split off Jr.)

[eoa]

Hello Tim, thanks for your insightful videos. I need your help to split up my time datas. 1:30am or pm was writing as 130 and 4:00 am was given as 400 without any delimiters. please how can this be resolved. Thanks

[RonenLin]

Can you dynamically split? For instance I have several records with 5, 6, 7 or 8 words and I want to split them on the space " " and create a column for each word.

[Owanango]

Hi Tim, this is cool stuff. How do you get it to return the default if unable to split? This happens in cases where the columns contain texts that either contain the character or is missing the character. For example if the character I am using to split is missing, how do I get it to return the "unsplit" text? I hope I am making sense. In other words, it is something like, if you are unable to split, return the previous string as-is. Thanks

[amgadnassif]

Hi Tim....Can we do word slice then filter on the slice as we do in PANDAS? for example if I want to know the names that start with First Initial, in pandas I would use slice, then filter using the LOC function on the names that has a period or a space in position 1 where first letter comes in position ZERO and the second letter in position 1

[brianbruno]

Hi Tim, I have some invalid data in my city category and the reason they are invalid is because they aren't cities but rather census. I want to create a split where I split my invalid string names from city and have a new column named census. But not quite sure how to do it

[chiemeriechibuzor]

hi Tim, I can't find the split function. I am trying to create maps, to separate city from the state, but I can't find spilt function, I see only hide, create and oh thanks so much Tim, I have seen it. I seem to be using an old tutorial

[Mohammad-rzoj]

Hi Tim, Could you please help in my requirement "i have a column which i am splitting with help of '-' but what happening is that for some rows i have two hyphens like this '--'. for example : lets i have two rows like 1) Paper-Pen 2) paper--pen' for this two rows if split basing on '-' we only get 1st row correctly like Pen but for 2nd row we will blank". I hope you got it. Please help me to solve such issues like this.