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

      Hello

       

      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.

       

      Thanks