1 Reply Latest reply on Jan 31, 2018 12:45 PM by Norbert Maijoor

    Dynamic column renaming in Tableau

    Rakesh Parikkal

      Hi,

       

      I have a data file like this where col1 and col2 names vary per engagement.  I have created a dashboard for engagement 1 with Col1 and Col2. However i would like to know is there a way in tableau which I can rename the column name dynamically in Tableau.

       

      Engagement1

        

      NameLocationCountryCol1Col2
      RajKochiindia13
      AjayKannurindia24
      PieterEdisonUSA35

       

      Engagement 2

       

        

      NameLocationCountryCol3Col4
      RajKochiindia13
      AjayKannurindia24
      PieterEdisonUSA35
        • 1. Re: Dynamic column renaming in Tableau
          Norbert Maijoor

          Hi Rakesh,,

           

          Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.

           

           

          1. Pivot the datasource. Pivoting is explained here

           

           

          2. Define two parameters

           

           

          3. D1. Dynamic Column Renaiming

           

          if [Pivot Field Names]="Col1" then [P1. Col1]

          elseif [Pivot Field Names]="Col2" then [P1. Col2]

          end

           

          4. Drag required objects to the indicated locations. Hide Header of Pivot Field Names and show parameter control

           

           

          Regards,

          Norbert

          1 of 1 people found this helpful