1 Reply Latest reply on Nov 1, 2016 8:24 AM by Andrew Watson

    TEXT Function in Tableau

    Sam Salmirs

      Hello -

       

      Trying to change data in a field to a fixed number of characters. If an ID is less than 8 characters, then 0's need to be added to arrive at 8 characters.

       

      Example:

      ID: ABC123, DEF45, 78

      Desired ID: 00ABC123, 000DEF45, 00000078

       

      This needs to be a calculated field.

       

      Thank you in advance for any help!

      Sam & Eliza