10 Replies Latest reply on Jul 29, 2018 11:00 PM by Tony Mao

    Unable to view VARCHAR data in mySQL on Tableau

    Srihari Chakrarajan

      Hi All.

      I am new to tableau and have been trying to connect it to my local mysql database where I have a repository of customer data to analyze. However, when I connect to the database and import the table, the all the columns shown as varchar or char are shown as blank fields in tableau. Does anyone know what is causing this?

       

      Below is the screenshot of table in mysql:

      Screen Shot 2018-06-10 at 4.19.00 AM.png

      And this is how it shows in tableau:

      Screen Shot 2018-06-10 at 4.18.30 AM.png

      But when I change the data type to whole number, I am able to see the 4th row data which I intentionally put in as all numeric. So its definitely not an issue in being able to read the database.

      Screen Shot 2018-06-10 at 4.18.48 AM.png

       

      Does anyone have any suggestions / ideas?

       

      Cheers,

      Hari