2 Replies Latest reply on Feb 12, 2016 5:43 AM by Mark Fraser

    Connecting to Excel with Data containing Null Values

    Kate Abercrombie

      Hello -

       

      I am working with an Excel file that dozens of fields that have null values along with numerical values. When I connect the Excel file to Tableau, these fields are classified as Dimensions. I then have to convert to a measure then change it to be a number (instead of Count Distinct). Is there an easier way do this conversion automatically? Also, if there is a solve to automatically replace all null values with zeros when I connect to the data, that would be really helpful.

       

      Thank you,

      Kate