5 Replies Latest reply on Feb 12, 2019 7:45 AM by Diego Parker

Splitting

hina.waheed.0 Feb 12, 2019 6:07 AM

Hello,

So I am little lost on this one-

I have a column that has names on there- however I need to split it in tableau prep in a way- where I see all the "levels" in a different column, whether it was "fusion" in a different column, and the actual name in a different column. I was able to split this however I get several fusion categories in a different column and levels in a different- I need both of these categories to have their own columns. How can I do that?

Attached is a mock up of the data along with what id like on the outcomes tab.

Thanks

Hina

Mock Data1.xlsx 10.2 KB

1. Re: Splitting

Jim Dehner Feb 12, 2019 6:28 AM (in response to hina.waheed.0)

please attach your twbx workbook (v an excel file) so we can see your approach and where you ran into problems - we are volunteers here to help you reach your goal
JIm
Like Show 0 Likes(0)

Actions
2. Re: Splitting

hina.waheed.0 Feb 12, 2019 6:53 AM (in response to Jim Dehner)
Hi Jim,

I am attaching my prep flow. As you can see my data isn't splitting evenly. I want a separate column with all the "fusion" & "levels" variables in one column, but in this data currently, I am getting mixed up information for both of those variables.

Splitting Data.tfl 2.4 KB
Like Show 0 Likes(0)

Actions
3. Re: Splitting

hina.waheed.0 Feb 12, 2019 7:07 AM (in response to hina.waheed.0)
Attached is the workbook

Splitting.twbx 6.5 KB
Like Show 0 Likes(0)

Actions
4. Re: Splitting

Ken Flerlage Feb 12, 2019 7:28 AM (in response to hina.waheed.0)

I'm not following you. Based on your sample input, what is the expected output?
Like Show 0 Likes(0)

Actions
5. Re: Splitting

Diego Parker Feb 12, 2019 7:45 AM (in response to hina.waheed.0)
Hey Hina,

Please find attached the Prep Flow and the CSV. What I did was to Split the last value to extract the levels and then used a LEFT & LEN formula to remove that part. Afterwards I splitted that last field.

I hope this helps. If you have any further questions do not hesitate on asking. If this answers your question please mark it as helpful/correct so other users can refer to it.

Also, you could do these steps in Tableau too, no need to use prep.

Best,
Diego.

Output.csv.zip 301 bytes

Splitting Data.tfl 2.9 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions