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

JethroChen
ファイアボール
スポイラ
challenge_81_jc.PNG
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

I make 2 version. Iterative Macro version and normal workflow.

スポイラ
AkimasaKajitani_0-1600571347124.png
AkimasaKajitani_1-1600571364273.png

 

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 81 is done!

 

Workflow:

スポイラ
Jonathan-Sherman_0-1602582826398.png

 

Macro:

スポイラ
challenge 81 JMS solution macro.PNG
johnemery
ボリード

Tough one for me

A2H
ボリード
スポイラ
Capture d’écran, le 2020-11-08 à 11.38.31.png
Hitch
アステロイド

Here's my attempt

Qiu
21 - Polaris
21 - Polaris

Burned my brain.

 

tammybrown_tds
コメット
スポイラ
tammybrown_tds_0-1610041883817.png

 

Tokimatsu
クエーサー

I liked @estherb47’s workflow so much. But if Line ID is not numbered properly, the workflow cannot calculate. I tried to use parent ID to solve it.

スポイラ
2021-01-16_12h24_55.png

estherb47
15 - Aurora
15 - Aurora

@Tokimatsu 

Thank you! Glad I could help out with an approach to this one.

Cheers!

Esther