community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #14: Warehouse Distribution

Alteryx Certified Partner

Went for the non-macro route.

Spoiler
challenge_14.PNG
Alteryx Certified Partner
Alteryx Certified Partner

Didn't feel the need to complicate it with macros! TOOLNAMEHERE FTW!

Alteryx Partner

Challenge 14 is done!

Spoiler
challenge 14 JMS solution.PNGchallenge 14 JMS solution formula.PNG
Asteroid

Finally, done

Asteroid

Not quite an answer to this challenge, but if anyone wants to learn a little about iterative macros, I've attached a packaged workflow that makes use of them.

 

 

Asteroid

👍

Alteryx Partner
 
Asteroid

Very interesting challenge, thank you!

Asteroid

Got to an answer using the multi-row formula tool. I tried sooooo hard to craft an iterative macro for it, but just couldn't get my head around how (I'm new to them). Time to look at what others have done and learn! :)

Asteroid

Here's what I got