3 Replies Latest reply: Oct 26, 2017 5:37 AM by Varun Prakash Paulraj RSS

    Transform a pivot in a table

    Simone Trabattoni

      Hi community,

      I have a problem of data management, and I hope to have put a clear title.

      I have this kind of data: some seller, some products, and the quantity of product sold in two months.

       

      seller  product  jan feb

      a         aa         1     2

      a         ab         2     3

      b         ba         3     1

      b         bb         3     8

       

      here in a way Qlik-edible waty;

       

      load*inline

      [ seller, product, jan, feb

      a,aa,1,2

      a,ab,2,3

      b,ba,3,1,

      b,bb,3,8

      ];

       

       

      I'd like to have the data in this way, using the load script:

       

      seller  product  month quantity

      a         aa          jan       1

      a         aa          feb       2

      a         ab         jan        2

      a         ab         feb        3

      b         ba         jan        3

      b         bb         feb        1

      b         ba         jan        3

      b         bb         feb        8

       

       

      how can I reach this?

      Thanks for your time