This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
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.
This enclosed spreadsheet is just sample of data. I have huge data from ERP and i need to implement one logic for all.
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
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?