2 Replies Latest reply: Sep 4, 2018 8:27 AM by Venkat Vemula RSS

    How to change columns into rows and concatenate data in columns

    Venkat Vemula

      Hi,

       

      I have below requirement in Qliksense. Could you please help me.

      I have data like below.

       

      IDREGION1REGION2REGION3REGION4
      1XX
      2XX
      3XX
      4XX
      5X

       

      i need to get data as below.

        

      IDREGION
      1REGION1;REGION4
      2REGION2,REGION3
      3REGION1,REGION2
      4REGION2,REGION3
      5REGION4

       

      Thanks in advance for your support.