1 Reply Latest reply on Aug 5, 2012 11:03 PM by Andy Harris

    Limit to number of characters displayed

    Robyn Stables

      Hi there,

      I have an excel spreadsheet which has a column with several comments.  Some of the comments have more than 900 characters.  Tableu is not displaying all of the characters.  Does anyone know how to control this.  I have attached a sample file showing the problem.  The top comment is truncated.

        • 1. Re: Limit to number of characters displayed
          Andy Harris

          Hi Robyn,

           

          The Microsoft JET engine database driver for Excel and Access has a limitation of 255 character, this is why only part of your comments are being displayed when you connect Tableau to your Excel file.

           

          If your source data sits within a database then you shouldnt have this problem and you'd be better connecting directly to the source. If the data only exists in excel then there is a workaround wherby you can split the comments in excel and then concatenate them after import and tableau will then display all characters.

           

          This thread may help you (there are some others of a similar nature as well)

          http://community.tableau.com/thread/107800

           

          hope this helps