We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #81: Multi-Level Bill of Materials Problem

gawa
16 - Nebula
16 - Nebula

There should exist smarter solution

Spoiler
image.png
tristank
11 - Bolide

These challenges haunt me but after an hour or so I figured it out using the iterative macro. Victory is oh so sweet

 

Spoiler
Screenshot 2023-08-24 212450.pngScreenshot 2023-08-24 212433.png
Sebastian_Chaieb2
11 - Bolide
11 - Bolide

I am not proud from that solution so I will have to back to it in the future and develop something nicer :) 

 

Spoiler
81_1.PNG

lwolfie
11 - Bolide

That took a minute to get the last bit worked out.

danielprince
7 - Meteor

My solution

Rob-Silk
8 - Asteroid

My solution below:

 

challenge_81a_RS_screencap.PNGchallenge_81b_RS_screencap.PNG

olga_strubbe
11 - Bolide

This was a fun challenge and a good practice for iterative macro.

Thank you, @Joe_Mako

 

2024-01-02_12-28-26.png

H_a_n_g_C_h_e_n__x3
8 - Asteroid

My Macro be lookin funny

Bobbyt23
13 - Pulsar

Went for the Macroless version and got my head in a right twist getting the numbers right but got there in the end.

Carolyn
12 - Quasar
12 - Quasar

Completed with an Iterative Macro that took 10 iterations to get through everything

 

Spoiler
2024-07-02_17-14-35.png

2024-07-02_17-16-55.png