2 Replies Latest reply on Aug 6, 2018 8:58 AM by Joshua Milligan

    Renaming during PIVOT step

    Neel Patel

      Hello Tableau family,

       

      Is this just a glitch or am i doing something wrong?

       

      Test.PNG

        • 1. Re: Renaming during PIVOT step
          Don Wise

          Hi Neel,

           

          This is a known issue in Tableau Prep per this KB article: Unable to Replace Edit or Group Values Containing "&" (ampersand) in Tableau Prep | Tableau Software

           

          Published: 01 Aug 2018

           

          Last Modified Date:

          03 Aug 2018

          Issue

          When using values containing the ampersand character "&", the value cannot be renamed or edited.

           

          Additionally, when using the 'Edit Value' option, the command is recorded as successfully completing in the Changes

          pane, however the value remains unchanged, and the renamed value not containing the ampersand is shown to be "not present in the data set".

          Environment

          Tableau Prep 2018.2.1

          Resolution

          Try one of the following workarounds:

          1. Use aliases or replace calculated field in Tableau Desktop.
          2. Use Tableau Prep 2018.1.2.

          Cause

          This behavior (ID: 807311) is currently under investigation.

           

          If this answers your question, please mark this response as correct so that others may find it useful in the future.  Thx, Don

          2 of 2 people found this helpful
          • 2. Re: Renaming during PIVOT step
            Joshua Milligan

            One other workaround not mentioned in the KB article is to replace the character with something else unused that doesn't have problems using a calculation.

             

            REPLACE([Field], "&", "|")  does NOT seem to work.

            However, you can replace the character using the CHAR() function, like this:

             

            REPLACE([Field], CHAR(38), "|")

            Field values would change from:

            AT&T               to      AT|T

            Fox & Hound   to     Fox | Hound

             

            I would do this very early in the flow (maybe even insert a step right after the Input).  Once the rest of the flow is done (pivots, grouping, etc...) then, at the end of the flow, reverse it to restore the ampersand:

             

            REPLACE([Modified Field], "|", CHAR(38))

             

            Also problematic are ">" and "<".  They can be addressed in the same way.  Hopefully this is fixed in the next release.

             

            Hope this helps,

            Joshua

            1 of 1 people found this helpful