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.



      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