We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #14: Warehouse Distribution

8 - Asteroid
Spoiler
8 - Asteroid

The same logic can be used during the pandemic period, to allocate critical resources.

Spoiler
First 40% items don't have enough stock to meet everyone's need.

Calculated remaining stock, when there is more stock than demand, allocate the demand according to the priority. When there is still stock, but less than demand, allocate to the rest of stock.
When there is no stock, allocate 0..

5 - Atom

solved without an iterative macro

7 - Meteor
Spoiler

8 - Asteroid
Spoiler

Spoiler

7 - Meteor

Tried Iterative Macro first time 🙂

Spoiler

7 - Meteor

I used the running total approach for my solution.

6 - Meteoroid

Hi! I'm also here to share my solution.

I did not use the macro approach though. I'm using the Multi-Row Tool to be able to get the same output and also because I don't know how to use the macros yet.

I began solving this Challenge after I solved Challenge 15 (because 15 is for Beginner level that's why I solved it first). Anyways, I was curious and since the values are almost the same, the familiarity of processing the data made it easier to solve.

7 - Meteor

Done 🙂

5 - Atom

My solution, w/o iterative macro, but with an additional summary on what is left in the main warehouse