Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"newbie question regarding market basket analysis"

i have a table with two columns
1. column: transaction id
2. column: product name

and i want to know which products are often bought together
with which algorithm can i do that?

thanks for any help!

Find more posts tagged with

AI Studio

Market Basket Analysis

Accepted answers

All comments

IngoRM

Hi,

the solution is the operator "Pivot". Search here in the forum for "Pivot" and you will many threads about this operator. There are also some examples on myExperiment.org which are available with our Community Extension (search for that as well).

Cheers,
Ingo

apon

thanks for the answer, helped me a lot

apon

sorry for the doublepost but i have a new question regarding this topic
i used "FPGrowth" and "Create Association Rules" to find out which items are bought together
the problem is as the result i get rules only for the firts 3 columns of the exampleset but i want rules for all items

what did i wrong?