2 Replies Latest reply on Sep 18, 2012 4:29 PM by David Powell

    eCommerce multicart purchases

    David Powell

      Hey all,

       

      Given the data from an ecommerce shopping cart where each cart can contain multiple product sku's, i am trying to find out the most popular combination of product skus which users are buying.

       

      The data i have is in this format:

       

      cart_idproduct_sku
      12388999
      12387999
      12390456
      22288999
      22287999
      22290456
      22688999

       

      is it possible to use tableau to combine this data in the following format: given the above data:

       

      product_sku_combinationunique_carts
      88999, 87999, 904562
      889991

       

      many thanks,

      Dave