4 Replies Latest reply on May 11, 2016 8:52 AM by Andres Castaneda

    Tableau imports real data from CSV file as missing (NULL) values

    Andres Castaneda

      Hi all,

      I have a dataset of 7.6 million observations in a csv file (delimited by “;”).  When I import it in Tableau one of the variables with range 0 to 1 has a lot of missing values, specifically for observations <1. Thus, my variable only has null values and values equal to 1. Using Stata (the statistical package that I use to create the csv file), I generated a subsample of only 1% of the total observations (say, about 76,000 obs) and loaded it in Tableau. It went through fine and no missing values was mistakenly created in my variable. How can I solve this?

      Thanks!

      Andrés.