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
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
I'm not following you. Based on your sample input, what is the expected output?
1 of 1 people found this helpful
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.