Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

cwkoops
8 - Asteroid

I repurposed a macro I use for BOM records that are structured differently....may have possibly just been easier to start from scratch as dealing with "Labor" (130-000), "Galvanising", and "MS Flat 80x8" gave me difficulty, as they show up in the Part Number column of the output multiple times with different "Full Quantity" values.

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1626200922011.png

 

Maskell_Rascal_1-1626200936815.png

 

Cheers!

Phil

PangHC
13 - Pulsar

try no luck to solve with no macro.

Elias_Nordlinder
11 - Bolide

Should probably go Iterative next time, oh well good exercise, managed it in the end still 🙂

 

Spoiler
Elias_Nordlinder_0-1627312657839.png

 

JoePC
9 - Comet

Solution Attached

Hub119
11 - Bolide
11 - Bolide

Solution attached.

ncrlelia
11 - Bolide

Challenge 081

AlexC2
8 - Asteroid

Tried doing it without an iterative macro, pretty challenging!

 

Spoiler
AlexC2_0-1629994424092.png

 

MichelleL
Alteryx
Alteryx

Non-macro route . . .

Erin
11 - Bolide

Took a little while, but got it! 

 

Spoiler
BronzeFox_0-1632853449729.png