1 Reply Latest reply: Jun 22, 2017 1:00 PM by Sergey Shuklin RSS

    Find products which were sold together

    Max Shevchenko

      Hi,

      From the data below I have to find products which were sold together in different ID's.

      For example, the combination of Product1 and Product3 were sold 3 times where Product 1 sold 3 pieces as well as Product3 has been sold 7 pieces.

      So I need result like this

       

      ProductsTogether    | Sold times together | Product  1st   |   Sold pieces | Product 2nd  | Sold pieces |

      Product1&Product3 | 3 times                       | Product1        | 3 pieces          | Product3       | 7 pieces       |

      Product1&Product2 | 1 time                         | Product1        | 1 piece             | Product2       | 5 pieces       |

      -- etc --

       

      Think such task should be done before. Please share your experience with me.

      Thank you in advance!

       

      Table:

      LOAD * Inline

      [ID, Product, Sold quantity

      001, Product1, 1

      001, Product2, 5

      001, Product3, 1

      002, Product1, 1

      002, Product3, 2

      003, Product1, 1

      003, Product3, 4

      003, Product5, 2

      ]