2 Replies Latest reply on Mar 14, 2014 7:15 AM by Traci DeGolier

    Field named "Year" contains numbers and text

    Traci DeGolier

      I have a column in my data that is named "Year".  However, the values in the field are not all numeric.  For example, we have the standard 2008, 2009, 2010, 2011, 2012, 2013, and 2014.  But we also have 14Budget and 14Stretch.  When I connect to this data source (Excel file), Tableau reads the "Year" field as a number (as opposed to a date) and appears to drop the records that contain 14Budget and 14Stretch.  I've tried changing the data type of the Year field to text and updating the extract, but still excludes those values.

       

      Any ideas??

       

      Thanks in advance.