1 Reply Latest reply on Jan 18, 2012 4:20 PM by Shawn Wallwork

    Field with leading zeroes getting converted to null in Tableau.

      Hello All,

       

      I have a comma delimited text file with 16 fixed width columns. One of these columns is the customer id number. The field is 19 byte with leading zeroes. Most my customer numbers are 5 digits in length. Tableau seems to only be recognizing the customer numbers that are 6 digits long or above. All of my customer numbers with 5 or less digits are coming back as null.

       

      I tried changing the data type to string instead of a number but, it doesn’t seem to correct this issue.  Is there another way I should be pulling in the data so that these customer numbers don’t get read in as nulls?

       

      Thanks in advance!

       

      -Jonathan