5 Replies Latest reply on Oct 1, 2013 9:55 AM by Samanta Dal Pont

    Tableau and Number formats in csv file

    Samanta Dal Pont

      Hi All,

      im using tableau 7

       

      i have a problem with my csv file and tableau.

      I had some columns formatted as "general" in the csv file (they are all numbers)

       

      Tableau didn't pick up some numbers and when i changed the format to "number" in the csv file it worked !

       

      in tableau the data type is set to "number" for those columns.

       

      And i have the other way experience. Numbers initially formatted to numbers in the csv file weren't picked up by tableau and then i changed to "general" formatting in the csv file and it worked.

       

      whats the deal between columns formats and tableau ? why it works sometimes and sometimes it doesn't ?

       

      thanks

       

      Kind regards,

      Sam

       

      Message was edited by: Samanta Dal Pont