1 of 1 people found this helpful
It does appear to be a current limitation of Tableau Prep. I do hope to see it addressed in future releases. Please vote here to lend your support to removing the restriction: https://community.tableau.com/ideas/9033
There might be a possible workaround with the REGEXP_EXTRACT_NTH() function to find the 10th instance of the semicolon along (and surrounding characters) and replacing that with something that can then be used to split out the field into two fields of less than 10 semicolons each that could then be individually split without exceeding the limit - but what a mess and I'm not entirely certain it would work without really working through all the steps. Maybe better would be to split by length of the field.
What you can do until this "feature" is changed is Edit one of the splits, Create a new Calculated Field, Paste the code and change the number at the end of the string to 11, repeat and change the number to 12, etc... I have not found a limitation this way. I will grant you, this can be a pain if you are splitting dozens of values off.
Life saver! I have 2019.1.2 and had to hand code an additional 14 splits. Downloading today! Thanks