In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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 #14: Warehouse Distribution

Johnny_Analytics
8 - Asteroid
Spoiler


Challenge_14_Main_Workflow.pngChallenge_14_Macro.png
ExploreMore
8 - Asteroid

My solution

Cosmin_S
8 - Asteroid

I used an iterative macro to reach to solution. Please find it attached. 

Thank you. 

DanielMS
Alteryx Alumni (Retired)
Spoiler
spoiler.PNG
Marcel_Gavrila
8 - Asteroid

Here's my solution!

Spoiler
Capture.JPG
piotrzawistowski
8 - Asteroid
 
DavidW
Alteryx Alumni (Retired)
Spoiler
Screenshot.png
David Wilcox
Senior Software Engineer
Alteryx
Reesetrain2
9 - Comet
9 - Comet

All,

 

My submission is attached.

Spoiler
-I was working on a solution that would work for one row and then convert it into an iterative MACRO. I ended up just finishing it without really needing the MACRO using Running Total and then Multi-row formula in order to clean up the zeroes and the negatives as there were a few case when you had shortages where the requirement was filled below the demand.

Capture.PNG

-Cheers!

Matt

 

lavanyadurai
7 - Meteor
Spoiler
Challenge14.PNG

 

alexo
8 - Asteroid

First time I found a use for the running total tool. Worked very well - the rest was just sorting and a simple formula.