Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

OnionKnight
Asteroide

this is my first time to touch Macro.

Sashikumar
Asteroide

Learned from Solution.

Spoiler
ch81.PNG
clmc9601
13 - Pulsar
13 - Pulsar

My solution

mpennington
Bólido

Attached.

 

Spoiler
MP 81.png
rcarog
Asteroide

Solution attached.

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1617371358752.png

 

Chantelb
Cometa
Spoiler
Chantelbbr_0-1617928267881.png

 

Chantelbbr_1-1617928277248.png

 

BeginnerMindset
Asteroide

Great challenge.  I went with an iterative macro.

 

Spoiler
BeginnerMindset_0-1618238153011.png

 

Spoiler
BeginnerMindset_1-1618238186225.png

 

JasonHu
Asteroide
Spoiler
workflow.png

Here is my submission, I was really struggling with this challenge and did it without macro. 

youngk313
Asteroide

Solution using join. Could use an iterative macro as well.