Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Alteryx Designer Logic for Component Identification

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

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

 

Labels