Cross Merchandising Application

a_raji

Hello everyone,

I need to extract association rules from a database that it organized in this way : 

Article_Code           Ticket ID

xxxxxxxxx1             yyyyyyyy1

xxxxxxxxx2             yyyyyyyy1

 

But the thing is, most of solutions that exist for that kind of need use the FP-growth then a Create Asssociation (Which is an Apriori algorithm). And these kind of algorithms only work on databases organized like this :

Ticket ID         Article1         Article2        Article3          Article4

yyyyyyy1         0                   1                 1                    0

yyyyyyy2         1                   1                 0                    0

 

Do you have any idea of how can i do to make my database treatable by the FP-Growth ?

 

MartinLiebig

The key operator for this is called "Pivot".

 

Best,

Martin