4 Replies Latest reply on Mar 23, 2012 11:24 AM by Alex Kerin

    Tableau concatenating values from 2 columns under one

      i am trying to show the data in a table format in tableau. the required format is shown in the attached file its an excel screenshot.

       

      Now the thing is everything goes fine until i find out ive replicated everything except for the MapName column, in which values dont repeat for every row. tableau just groups them bydefault.

       

      Finding the solution to this problem i added another column called sno and dropped it in front of Rows, which solves this problem

       

      But now its given rise to another strange problem.

       

      When i add all required fields , tableu starts to display  [srno + map name] under a common heading "Map Name"

       

      The attached picture concatenate_problem.png explains it nicely please refer to the picture.

       

      can someone please tell me how to fix this , im going nuts here with this problem