4 Replies Latest reply on Jan 17, 2019 4:12 AM by Zhouyi Zhang

    Combine multiple order rows to 1

    willem.brachel.0

      Hi all,

       

      I am trying to configure our database to correctly measure cross sell items, but unfortunately I don't really know how to do it.

       

      For example, this is how our order output looks like:

      OrderCustomer
      EmailCategory
      productPrice
      9844JohnJohn@doe.comBikesBike899
      9844JohnJohn@doe.comAccessoriesHelmet199
      9844JohnJohn@doe.comClothesShoes166

       

      In this example Bike is the main product, and accessories and clothes are cross sell items, I would like to show these cross sell items on the same row as the bike:

      Something like; IF category = Accessories then Accessories

       

      OrderCustomer
      EmailCategory
      productCross sell1Cross Sell2
      9844JohnJohn@doe.comBikesBikeAccessoriesClothes
      9844JohnJohn@doe.comAccessoriesHelmetAccessoriesClothes
      9844JohnJohn@doe.comClothesShoesAccessoriesClothes

       

       

      Someone knows how to achieve this?