Matching Items in the Same List

Question

This is the list of which material goes into what semi finished good/finished good that I start with:

And I would like to turn it into this structure:

Any suggestions on how to get the data into this format?

I've tried joining the data with itself and then that output with the original data, but all I get is the first two product hierarchies. Is this the best way to go about this? I'm pretty new to Alteryx so I don't know all the in's and out's yet.

Material Example.xlsx

Greg_Murray · Answer

Hi @MaryGraceP,

This gets to the answer in the example, but it's not a simple workflow. There is probably better solutions out there.

iterative contents.yxzp

MaryGraceP · Answer

Can you give me an example of what that would look like?

Qiu · Answer

@MaryGraceP

This looks like the router finder, and an iterative macro might be required.