MB Rules Limitations

[CRowlatt]

Hi Alteryx Community,

I'm working on basket analysis to try and find spending patterns and how they have changed over time. 

I've watched videos, tutorials and webinars on the MB Tools in Alteryx and thought they are perfect.

I can get them working with sample data but I am working with a data set of 6 months with 15 million lines and whenever I run the workflow the MB Rules tool gets to 11% and doesn't progress any more.

In the control parameters I've tried setting to higher numbers (believing that will create less rules and therefore be easier to process). I've tried cutting down to a week's worth of data (500K lines) and set the parameters in any which way but am always getting stuck at 11%.

I'm using one item per record, two columns (Transaction Key and Product Code, if I cross tab to get them on a single line the cross tab truncates the column), and my method is set to Apriori Association Rules.

Any help/insight is appreciated.

[Aguisande]

Hi @CRowlatt 

MB Rules is a very heavy process.

Maybe you can use MB Affinity tool to get co-ocurrence or cosine similarity to do the same pattern analysis, which is a very light process compared to MB Rules.

The amount of transactions in the data sample is no matter, but the amount of SKUs might be.

You can find more help here: https://help.alteryx.com/2019.1/MB_Affinity.htm

Hope this helps pointing you in the right direction.

[Meszi1899]

Hi All,

I have a similar issue and I would like to ask for your help. 

I constantly get the following error: MB Rules: Error in asMethod(object) :  can coerce list with atomic components only

Do you have any assumption what it means exactly and how I can solve it?

Many thanks,