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 #14: Warehouse Distribution

AndrewS
11 - Bolide

#14 - too many sorts but it works. Avoided iterative macro.

apabonok
8 - Asteroid

Hi. My solution, without macros.

 

Spoiler
challenge_14_apabonok_spoiler.png
jacob_kahn
12 - Quasar

@joshuaburkhow ,

 

Your posts are some of my favorite. This is the most simple way I've seen anyone solve this issue #inspiration

 

Thanks and see you around man.

 

Jacob

joshuaburkhow
ACE Emeritus
ACE Emeritus

Yeah bruda! appreciate it. Some of them are fun to try to solve in more elegant ways! So much to learn from everyone!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
jacob_kahn
12 - Quasar

I want to give kudos to @Kenda - your iteration really assisted me in figuring out this challenge. 

I still do not understand iterative macros, but get a little more comfortable with every challenge.

 

Thanks - please see my iterative solution attached.

 

 

Spoiler
macro.jpg

dashakir1
8 - Asteroid

Thanks GeneR.

LindaLo
8 - Asteroid

Interesting challenge...

The first idea pops out to my mind is using iterative macro instead of using multi row formula.

Check it out!

johnemery
11 - Bolide

I challenged myself with the iterative macro approach. Got it with no hints or anything, so I'm quite happy.

 

Spoiler
Solution Capture.PNGMacro Solution Capture.PNG
Simonvm9114
8 - Asteroid

Here's my solution. Took a bit more steps then necessary with hindsight. 

AdrienGohy
8 - Asteroid

Thank you for the challenge, the level is more than intermediate in my opinion.