1 Reply Latest reply on Oct 7, 2013 11:06 AM by Matt Lutton

    Failed to import all records while connecting to data source (excel or txt)

    Peter Sabela

      I have Excel data source that has 5002 records.   One of the columns contains 5 digit values -- 5000 of these values are 5 digit numbers, but 2 values start with a character.  During connecting to data source, Tableau heuristics will classify this column as numeric and seem to fail import the records which contain the two alpha-numeric values. 

       

      What should i do to reliably import the data if I suspect that not all values in column may be numeric?   Can the heuristics be turned off?

       

      (I was using 5002 records just for explanation, the data source i am working with and having this issue has 927,000 records)