6 Replies Latest reply on Jun 1, 2016 6:52 PM by William Matthews

    Table with 20 Columns

    anoop.mohandas.0

      Hey there,

       

      Is it possible to display around 20-22 fields as columns/rows in tableau without the table becoming very clustered or not readable.

       

      Thanks, AMD

      Delete.png

        • 1. Re: Table with 20 Columns
          Russ Lyman

          You can include a maximum of 16 Columns and Rows in a text table. The default number of Columns/Rows is set at 6. When you exceed 6, as in your example above, it will combine multiple fields together unless you change the Table Layout settings.

           

          To change the Table Layout and increase the number of columns and rows in your table, go to:

          - Analysis > Table Layout > Advanced

          - Then select the options shown in the screenshot.

           

          Good luck!

           

          SS2.JPG

          1 of 1 people found this helpful
          • 2. Re: Table with 20 Columns
            anoop.mohandas.0

            Russ,

             

            That really helped. Is there a way I can display it as below? i.e the table columns shown as a row instead as a column?Delete.png

            • 3. Re: Table with 20 Columns
              Russ Lyman

              Anoop,

               

              There's no way to display it that way unless you have those fields as a member of a single dimension (i.e., it would need to be in the same column in Excel). Each time you drag a dimension to the rows shelf, Tableau produces a row for each dimension member (not for each dimension). You can't stack separate dimensions on top of each other.

               

              Category is a dimension. Furniture, Technology, and Office Supplies are members within the Category dimension. Tableau creates its rows for the dimension members, not for the dimensions themselves.

               

              You might need to re-structure your data in order to accomplish what you're trying to do.

              1 of 1 people found this helpful
              • 4. Re: Table with 20 Columns
                kettan

                You might find a workaround in  Is there a way to achieve form view?

                 

                Related Questions:

                2015-12-03   Re: Table with 20 Columns

                2015-12-01   Display field labels vertically

                2015-11-19   Display dimensions in grid-like format

                2015-11-04   Is there a way to achieve form view?

                4 of 4 people found this helpful
                • 5. Re: Table with 20 Columns
                  Tableau kumar

                  More than 16 columns (row headers) in Tableau

                   

                  As you well know if you are reading this post, Tableau only allows 16 row headers/labels in a single visualization before it starts concatenating the header values.  The default is actually 6 headers until it starts to concatenate but this can be increased if you go to the menu Analysis->Table Layout->Advanced

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                  But what if you want more than 16?

                   

                  https://www.blogger.com/blogger.g?blogID=296082317844402109https://www.blogger.com/blogger.g?blogID=296082317844402109https://www.blogger.com/blogger.g?blogID=296082317844402109https://www.blogger.com/blogger.g?blogID=296082317844402109Note 1:  I first want to say that no good analysis can stem from a text report that has 16+ columns in it.  However I understand sometimes folks just want to show some drilldown detail that can be exported to csv/excel/etc.

                  Note 2:  If you are using this workaround to be able to display/export larger tables from Tableau, it is not a good idea to treat a Data Visualization application like an ETL tool.  You are using Tableau wrong.

                  Note 3: This is not supported.  At all.  If something breaks please dont email Tableau Support about it.  This hack comes 'as-is'.

                  Note 4:  I think this hack will work if you want to put a few extra columns (maybe like 20 total), but dont go crazy with it and try to put 50 columns out there.

                   

                  The only way to do this is to hack the XML of the .twb (wookbook) file.  If you save your file as a .twb, then right-click on it and choose to open it in a text editor (I like Notepad++), you can search for the term attr='row-levels' and you will find this section of the XML:

                   

                   

                   

                   

                   

                   

                  If you change those numbers to whatever else you want, then save your file (be sure if you choose 'save as' that you save as the file type 'All files' in the dropdown at the bottom and add '.twb' to your file name - i.e. dont save it as '.txt').  When you open it in tableau next, you will be able to add that many dimensions to the Rows shelf before it starts to concatenate the headers.

                   

                  Result (I typed in 21):

                   

                   

                   

                   


                  Note:  You can only open .twb files to see the XML in a text editor.  If you have already saved your file as a .twbx you can right-click on the icon and choose 'unpackage'.  This will create a .twb file and a folder with all the excel files/extracts/images/etc that were part of the packaged workbook.

                  Note:  If you go back into Analysis->Table Layout->Advanced it will still say the last numbers you entered in the UI, not the new numbers you manually entered into the XML, just ignore them.
                  Again, I do not condone this behavior, but sometimes you just need 'a fix'.

                   

                  Note:  Dimension headers will never get a scroll bar in Tableau (only items in the 'pane' are scrollable).  Tableau always expect you are building a chart and doesnt expect you will display tons of text columns.  Therefore you must put your view on a dashboard and fix the size to be big enough to hold your entire view (width wise).  I like to set mine to 'Range' and then set a Min size but no Max (the height on the Min can be small, but the width must be large enough to fit all your fields).

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                  7 of 7 people found this helpful
                  • 6. Re: Table with 20 Columns
                    William Matthews

                    This doesn't work for me. I'm using version 9.2.4 and I tried the steps above. I edited the xml in notepad and changed the value to 25. I saved the file then I opened the Tableau notebook normally. I checked the worksheet I had already build that had all of the fields in it. There was no change and I couldn't get all of the fields to display in the worksheet. I also tried adding the worksheet to a dashboard and manually adjusting the fields but it still doesn't work. I then tried building a new worksheet from scratch and it still doesn't display all of the fields that I wanted to see.

                     

                    Any ideas?