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 |
