how do your data look like? Please give a example of what you have.
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?
On Mon, 5 Oct 2009 09:21:26 -0700, kondal <kondal717@GMAIL.COM> wrote:
>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.
>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
>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