2 Replies Latest reply: Jul 30, 2018 7:59 PM by Rob Wunderlich RSS

    Table Transformation - Customer Journey (Products)

    Samuel Lin

      Hi Qlikers,

       

      If I have a table:

       

      CustomerIDOrderRankPurchased Product
      1231productA
      ...1productB
      ...2productA
      ...2productK
      1233productJ

       

      and I would like to get the following table:

      CustomerIDFirst Purchased ProductSecond Purchased ProductThird Purchased Product
      123productAproductAproductJ
      ...productAproductKproductJ
      ...productBproductAproductJ
      ...productBproductKproductJ

       

      so then in aggregate, i can look at the number of customers who purchased from productA to productA to productJ, basically to figure out the most popular customer purchasing path.

       

      Does anyone know an easy way to achieve this table transformation?

       

      Thank you!

      Samuel