Alteryx Designer Logic for Component Identification

[RAHULMISHRA]

I have to an analysis for a Business. There are many products which are getting manufactured in Factory. Now, Product A is made up of 1,2,3,4,5,6. Now, 1 is made up of 2,15,16. 3 is made up of 11,12,13 and 14. Hence, I need a output of only base component 2,15,16,11,12,13,14,4,5,6 as output. Please see  excel enclosed to understand How I need output. Please help me to build the logic/ workflow so that i can implement this for entire ERP Data.

[RAHULMISHRA]

This enclosed spreadsheet is just sample of data. I have huge data from ERP and i need to implement one logic for all. 

[fmvizcaino]

Hi @RAHULMISHRA ,

Attached is an example showing how to get that done for component A.

Let me know if that works for you.

Best,

Fernando Vizcaino

[RAHULMISHRA]

Product A was just for example. In my database, we have 1000 product. Please build a common logic which can be applicable for entire column instead of filtering one product at a time?