-
1. Re: Splitting
Jim DehnerFeb 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
-
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
-
-
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
-
-
4. Re: Splitting
Ken FlerlageFeb 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?
-
5. Re: Splitting
Diego ParkerFeb 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
-