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


      and I would like to get the following table:

      CustomerIDFirst Purchased ProductSecond Purchased ProductThird Purchased Product


      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!