3 Replies Latest reply on Feb 25, 2013 1:41 PM by Tracy Rodgers

    How to keep char format when reading from TXT file

    Armando Ramirez



      I have a TXT file with this column named StoreID.

      Some examples of values for this column are:

      0107, 3456, 004589, 09888


      When pulling into Tableau, these values are automatically converted to INT and, obviously, the StoreID column is identified as METRIC. So values are shown as:


      107, 3456, 4589, 9888


      How can I keep the original format and still be getting the "0"s?? and so the StoreID is kept as Dimension.