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|