2 Replies Latest reply on Aug 28, 2013 6:03 PM by Dan Cory

    Tableau data import fails for integers larger than 2^31 (2,147,483,648)

    Ryan Brideau

      I am working with data that has values that go into the high billions. By default, our monitoring software outputs these numbers as integers which we store in a CSV file to load into Tableau. I noticed today that every number larger than 2^31, however, was NULL.

       

      The fix is pretty simple on our end (we just need to record the number in millions instead) but it took me a while to figure out what was causing my graph not to display properly. Could be worth having a warning on the text-file load if your values are of a certain size that they might cause issues, or perhaps Tableau could convert them to floating point on the way in.