Search association rules

[vtatarnikov]

Hello! Give please advice on the creation of recommendations.
I have found a pair of items that bought in succession within three months.
Table 1 - is the purchases of a particular client. How to create a table 2?
I plan to find a pair of goods and calculate the frequency of their occurrence.
In the right direction I move?
I would appreciate any advice!

In Table 1, are: the date of the check, id of the check, products in check. 

In Table 2, there are a pair of products:

Product 2=b (id_product=b in the check=2 in table 1) has been sold after the Product 1=a (id_product=a in the check=1 in table 1) within 3 months ([date of id_document=2] deduct [date of id_document=1] <= 90 days)

etc.

Сообщение отредактировано: Vladislav Tatarnikov

[qlikviewwizard]

What is the relation beteen id_product ,Product1 and Product2?

[vtatarnikov]

Products B and C was sold after the product A within 3 months

[fvelascog72]

Hi, Vladislav,

Colud you be more specific explaining the relation between dates, ids and products fields.

Thanks,

[vtatarnikov]

In Table 1, are: the date of the check, id of the check, products in check. 

In Table 2, there are a pair of products: Product 2=b (id_product=b in the check=2 in table 1) has been sold after the Product 1=a (id_product=a in the check=1 in table 1) within 3 months ([date of id_document=2] deduct [date of id_document=1] <= 90 days)

etc.