Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx Designer Logic for Component Identification

8 - Asteroid

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.

8 - Asteroid

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

Alteryx Certified Partner
Alteryx Certified Partner



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



Let me know if that works for you.


Fernando Vizcaino

8 - Asteroid

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?