alteryx Community

Weekly Challenge

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.

Challenge #81: Multi-Level Bill of Materials Problem

12 - Quasar
Spoiler
Always good to prcatice iterative macro skills
19 - Altair

Woohoo.  1st iterative macro!

I set this one aside after trying it about a month ago, when I first started Alteryx. While I've developed many recursive solutions in my time, they were always in procedural languages.  This is the first one I've tried in a declarative language.  I had trouble mapping the looping,data set reduction and stop conditions that I was familiar with to their Alteryx equivalents.

A little patience and a lot of practice and I know how many wheel washers go on a car!

Spoiler

Dan

11 - Bolide

Solution attached. I took the macro approach as this seemed like the real-life approach to a real-life problem. I was interested to see if any of the standard workflow approaches accomplished a flexible (i.e. variable number of levels), recursive join. The solutions using multiple Join tools appeared to be hard-coded to four levels. Other solutions appeared to assume that the Line Id had intelligence were always in a particular order, and possibly that a single part did not appear in multiple BOMs. The solution from @patrick_digan appears to accomplish a flexible, recursive join, but it was very hard to follow and I'm not sure the concatenated List field could handle any volume of BOMs. I would be interested to know if a standard SQL recursive query can be accomplished in a standard Alteryx workflow.

Spoiler
11 - Bolide

Cheers!

10 - Fireball

Working through the steps to get to the 4 levels in the provided data made it really clear how to convert the repeated steps into an iterative macro.

Spoiler
11 - Bolide

Iterative whenever I can...

Spoiler
Main workflowIterative
8 - Asteroid

Tough One!

Spoiler
11 - Bolide

Fun little Parent-Child Iterative Macro

8 - Asteroid

The hardest challenge for me so far! and my first iterative macro... thanks to previous posters for the help!

8 - Asteroid

Here is my solution