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

mikeprice17
8 - Asteroid

Legit doesn't make sense to me. For some reasons levels 1-3 solved right away and with a single join. Woulda thought it would only solve levels 1-2 and then I would iterate through. Whatever.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

tiffanyshaw
8 - Asteroid

I built the iterative macro as a build-a-long (I needed the practice to see how they worked), so I went ahead and did a non-macro solution. 

 

Spoiler
tiffanyshaw_0-1588352510672.png

 

G_Thompson
8 - Asteroid

This brought back memories of when I worked for a major motor manufacturer and I had to build a solution to accurately cost movements in the BOM!!!

VizChic
11 - Bolide

keep ticking off the challenges 🙂

CKP
10 - Fireball

My solution

 

Spoiler
challenge_81_mysolution.jpg

 

phottovy
13 - Pulsar
13 - Pulsar

Super inefficient but gets to the right answer. I should have built a macro.

AngelosPachis
16 - Nebula

Personally I consider this challenge to be one of the most difficult intermediate challenges in the community. I'm really happy I solved it without using an iterative macro and kept the tool count relatively low 😄

 

Annotation 2020-07-01 175030.png

ArnavS
Alteryx
Alteryx

Completed

jaschirmer
7 - Meteor

Here's my macro-less solution.