MB Tool "No Valid Fields Were Selected" error

Question

Hello World. I'm having errors when using the MB Tool for Basket Analysis. My workflow is attached.

order_number is my transaction key (unique), and sub_class_num is my item key (1 or more for a given transaction).

When I attempt to use the first option "One item per record with a transaction key", I get the error "No Valid Fields were Selected".

I attempt to use the second option "One transaction per record with all in a single field". I first concatenate my data using a "|" separator. I do not receive an error, but the results are nonsensical: My left/right columns are single digit numbers, rather than the expected 8 digits of my sub_class_num field. Also, the MB Rules Report has Most Frequent Counts that are in the hundreds of thousands, when my dataset is only composed of 50,000 rows.

(first option)

(second option with nonsensical sub class num pairings)

Thanks for your help.

Ecomm Fulfilled Transactions for forum.yxdb

2. Basket Analysis Processing for Forum.yxmd

schaferc · Answer

Thanks @martin, and sorry for the delay in responding. I'll do some more investigating and see it goes. Cheers.

martinding · Answer

Hi @schaferc

I changed the configuration of MB Rules to Frequent Item sets, and results should be more consistent with your expectations (Frequent Item count in thousands rather than hundreds of thousands).

If all you need is the frequent item sets, then this should do.

In terms of Association Rules, I checked the input data types, and they are both valid (accepts either string or int), so I can't figure out why it give s the "No valid fields were selected error".

Spoiler