Market Basket Analysis (MB tools?)

[muddobber26]

Hello - I am currently trying to evaluate different Alteryx methods to do a "market basket" type analysis. Basically I have a list of Part Numbers that are tied to Parent Part Numbers. Think of Part Numbers as components and a Parent Part Number as the sellable part that is composed of a bunch of Part Numbers beneath it. 

Basically I am trying to look at different combinations of Part Numbers and see which part numbers occur most often TOGETHER. I.e., Every time THIS part number is tied to a parent part number than there is a high probability that THIS other part number accompanies it. See below for an example (the data set I am actually working with has 800000+ rows). My goal is to output common subgroupings of part numbers. 

Parent Part Number	Part Number
123456-00	456789-00
123456-00	456789-01
123456-00	456789-02
123456-00	456789-03
123456-00	456789-04
123457-00	456789-03
123457-00	456789-04
123457-00	456789-05
123457-00	456789-06
123458-00	456789-00
123458-00	456789-01
123458-00	456789-02
123458-00	456789-04
123458-00	456789-05
123458-00	456789-06
123458-00	456789-03

[Luke_C]

Hi @muddobber26 

Have you tried the MB tools in the predictive grouping palette? You just have to install the predictive tools, found in the same place you downloaded designer.

[muddobber26]

Yes. I have been running into issues running them. Any thoughts?

[muddobber26]

Here is my workflow.

[muddobber26]

Any thoughts on this?