3 Replies Latest reply on Mar 26, 2012 1:32 PM by Alex Kerin

    text values coming in as null

    Raoul Leblanc

      I have an excel file with a column of data in which most of the data are assigned with a number 1 through 5, but for which some rows are text.  When I import into tableau and try to use this column or filter on it, the individual numbers show up, but Tableau has collapsed all the text values to Null.  I have made the data type a string (and even refreshed the extract), but this does not appear to change the situation.  I want to see all of the text values since I may want to filter on one or more of them.

       

      Thoughts?