3 Replies Latest reply: Apr 11, 2018 3:44 AM by Petter Skjolden RSS

    Converting data in Qlik sense

    Poojashri Bangera

      Hi,

       

       

      I have data like this

       

      id       year     rating_type     rating

      101    2015        A                   X

      101    2015        M                  C

      102    2016        A                   X

      102    2015        A                   L

      103    2017        A                   X

      104    2016        A                   X

      104    2015        M                  C


        i want data like this in qlik sense

       

      how can i achieve this.

      please help.

      id2015_A2015_M2016_A2016_M2017_A2017_M
      101XC
      102LX
      103X
      104CX