4 Replies Latest reply on May 2, 2017 11:30 AM by Norbert Maijoor

    Keeping Leading Zeros

    Rylee Iacolucci

      Hi,

       

      In my dataset I have a lot of Part Numbers that contain leading zeros. When I copy and paste these from tableau desktop these will get deleted rendering the part number invalid since it can not be referenced correctly. I need these part numbers to keep their leading zeros especially since other people in my department are downloading data from tableau online. I've tried creating calculated fields like STR(Item), but this doesn't work the way I need it to.

       

      Example Part Numbers:

       

      0001AB

      00235IA

      01119Bl

      0-AB324100

      0-013BNA