community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #81: Multi-Level Bill of Materials Problem

Fireball

I tried for too long to get a non iterative approach. Wasnt as complete as i would have liked so i gave in. 

 

Quasar

Solution attached.

Alteryx Certified Partner

Took me quite a while to complete this challenge. I wanted to find a dynamic solution for any number of levels, and struggled to do it for more than 3 levels without an iterative macro. At the end I went for an iterative macro, which was a variation of a macro I did in challenge #12. 

 

I also checked other's non-iterative solutions with an altered input of up to 8 level of BoM and solutions by @patrick_digan and @EstherB47 handled that properly. Impressive! Definitely going to study them closely! 

 

Spoiler
Screen Shot 2018-01-08 at 19.31.38.pngScreen Shot 2018-01-08 at 19.31.49.png

 

 

Alteryx Certified Partner

This one really puzzled me, so I worked through @EstherB47's solution until it fell into place.

 

Spoiler
solution_81_JL.png
Asteroid

Challenge Completed

Asteroid

I definitely need more practice with iterative macros, but eventually figured it out! Pretty similar to the given solution.

Asteroid

Here's my attempted solution. Interesting to see the different ways to pass in either the starting element or all data and then either filter within the iterative macro or filter beforehand. For some reason it makes more sense in my head to filter outside of the macro and have the data also in the macro. Maybe bad design (less dynamic), but it works in my head better for now!

Alteryx Certified Partner

Follow my solution package attached...

Asteroid

Here's my solution :)

 

Spoiler
Challenge 81.jpg
Asteroid

Having never worked in Manufacturing, this challenge was quite hard for me to get my head around, however I eventually figured out the trick! Thanks

 

Spoiler
Iteractive Macro!