Alteryx designer Discussions

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

Alteryx Designer Logic for Component Identification

Highlighted
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.

Highlighted
Asteroid

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

Highlighted
Alteryx Certified Partner

Hi @RAHULMISHRA ,

 

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

fmvizcaino_0-1580105313142.png

 

Let me know if that works for you.

Best,

Fernando Vizcaino

Highlighted
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? 

 

Labels