Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #81: Multi-Level Bill of Materials Problem

Highlighted
13 - Pulsar

Tried to do this without a macro, but realized an iterative macro was much easier.  Originally put nulls as placeholders for both parent quantity and full quantity, but then had to do several additional steps that didn't quite work to fix.  Ended up with almost the same result as the given solution.

Spoiler
Workflow 81.JPG

 

Macro 81.JPG

 

 

Highlighted
10 - Fireball
Spoiler
Completely blanked on making a sensible iterative macro condition but made it in the end

image.pngimage.png
Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_81_RODO_Solution.pngchallenge_81_RODO_Solution_Macro.png

 

 

Highlighted
8 - Asteroid
Spoiler
Here's the two iterations without an iterative macroHere's the two iterations without an iterative macro
Highlighted
8 - Asteroid

My solution;

Highlighted
8 - Asteroid

My Effort, using an iterative macro

 

Spoiler
Flow

JamesCameron_0-1577378655880.png

Macro

JamesCameron_1-1577378701249.png
Highlighted
8 - Asteroid
 
Highlighted
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture1.PNGCapture.PNG
Highlighted
8 - Asteroid
Spoiler
Challenge 81 2020-01-20.jpg
Highlighted
8 - Asteroid