1 Reply Latest reply on Aug 28, 2018 10:43 AM by Joshua Milligan

    Tableau Prep Custom Split Limit

    Amelia Shank

      There is a column in my data that I need to split and pivot. The column represents evaluation results and there are rows that reach up to 20 different results, with each result split by a semicolon. I am running into an issue with the Split capabilities of Tableau Prep with the amount of fields the split creates. I have tried both the Automatic and Custom split and had more success with the Custom split.

       

      When I have done the Automatic Split on the column, the data is split into only two separate columns, with the rest of the data (after the second semi colon) completely truncated. Using the custom split, I specified a semicolon as the delimiter and and chose to split of "All" fields.

       

      The result of the custom split is only 10 different columns, when I know there should be 20. The data after the 10th semicolon is completely lost.

       

      I've been working around this by doing the step manually in Excel prior to loading into Prep, but was wondering if there is a way around this or if this is just a limitation of Tableau Prep right now.

        • 1. Re: Tableau Prep Custom Split Limit
          Joshua Milligan

          Ameila,

           

          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.

           

          Best Regards,

          Joshua

          1 of 1 people found this helpful