The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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

martinding
Pulsar

 

Révélation

81a.png

81.png

 

  

AndrewHoData
Astéroïde

Find solution attached

Révélation
AndrewHoData_0-1669445582602.png

 

FinnCharlton
Pulsar
Révélation
FinnCharlton_0-1669629701286.png

 

JamesCharnley
Pulsar
Révélation
JamesCharnley_0-1669630285830.png

 

This was a bit of an accidental solution for me but this has been a nemesis challenge for me so glad it's done

Ladarthure
14 - Magnetar
14 - Magnetar

My solution with an iterative macro

SkomantasTamulaitis
Astéroïde

Found this one pretty tough. Definitely need more practice with iterative macros. 

Révélation
Screenshot 2022-12-17 085606.pngScreenshot 2022-12-17 085633.png
ahsanaali
Bolide
Révélation
ahsanaali_0-1671627620786.png

 

kristiadiuisan
Astéroïde
Révélation
Alteryx_challenge_81_KU.png
Macro
Alteryx_challenge_81_KU macro.png
leonhekkert
Astéroïde

Went for the iterative macro which was nice practice:

 

 

Révélation
Challenge_81.png


 

 

alacoume
Comète

My solution: