how do your data look like? Please give a example of what you have.

eg:

cust_id p1 p2 p3 p4 .... p10 1 0 2 0 5 3 2 1 5 2 0 0 3 0 0 3 0 8

for the number of ordered pieces of p1, p2, p3, ...

or in any other form?

Gerhard

On Mon, 5 Oct 2009 09:21:26 -0700, kondal <kondal717@GMAIL.COM> wrote:

>Dear Friends >To find the repeating or same set of products in the orders. or the >repeating patterns or groups of the same orders made by the customers. > >Example: >first customer ordered products are 1,2,3,4,5,6,7,8,9,10 >second customer ordered products are products 1,4,6,7,8 >third customer ordered products are products 1,2,4,6,9 >fourth customer ordered products are products 1,2,3,4,5, >fifth customer ordered products are products 6,7,8,9 >Like 2500 customers are ordered different Products. > >Now I would like to know 2 or more same set or Cluster or group of >products ordered; >if it is 2 products then , products (1, 4) >if its more than 2 , products (1,4,6) is one group or cluster of >products which are ordered together for so many times and like wise >products (6,7,8,9) is one group , products (1,2,3,4,5) is one group , >products ( 1,2,4) is one cluster, like wise........ > >Help me in code