1 Reply Latest reply: Feb 23, 2017 1:32 AM by shweta Singh RSS

    Dynamic Column Name

    shweta Singh

      Hi Everyone ,

       

      I stuck in the requirement ,looking for your suugestion

      Table A  have list of data for different column but the name of this data column should assign on the basis of the Name present in Table B i.e. Data_1 should be changed as Country and Data_2 as Product ,

      If the name of Data_1 is change as XXX in Table B  ,then it should automatically changed in the output table

       

        Table A :

       

       

      Data_1Data_2Data_3Data_4Data_5Data_6Data_7
      USA100Bread
      INB200chocolate
      PAKC300Pen

       

       

        Table B :

       

      GroupName
      Data_1Country
      Data_2Product
      Data_3Qty
      Data_4Name
      Data_5
      Data_6
      Data_7


      Required output

       

       

      CountryProductQtyNameData_5Data_6Data_7
      USA100Bread
      INB200chocolate
      PAKC300Pen

       

       

      Please  find the sample qvw