2 Replies Latest reply on Jan 16, 2012 5:10 PM by Kevin Lee

    Should I convert discrete variables into integers and join with a mapping file to improve performance?

    Kevin Lee

      We're trying to import a 1m+ row CSV into Tableau, and because the visualisations require quite a bit of number crunching, the performance of the Desktop & Reader files have been pretty poor.

       

      There are a lot of discrete variables (eg Country, Category etc) that are currently stored in the CSV as strings. We were wondering whether we'd improve the performance of our Tableau fiels if we converted them all into integers in the CSV, and then load in the lighter CSV into Tableau, along with a mapping file for Tableau to join? Has anyone tried this and noticed a significant improvement in performance?

       

      Thanks!