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.

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

aheikes
8 - Asteroid
Spoiler
Challenge14.JPG
steven4320555
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.

steven4320555_0-1585927325559.png


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.. 

steven4320555_1-1585931811542.png

 

Blake_L
5 - Atom

solved without an iterative macro

Ivyin702
7 - Meteor
Spoiler
Ivyin702_0-1586599032737.png

 

igorp
8 - Asteroid
Spoiler
igorp_0-1586622993121.png

 

Spoiler
igorp_1-1586623008085.png

 

MOHAMMEDAFZAL
7 - Meteor

Tried Iterative Macro first time 🙂

Spoiler
MOHAMMEDAFZAL_0-1586624434613.pngMOHAMMEDAFZAL_1-1586624460414.png

 

Bernhardt03
7 - Meteor

I used the running total approach for my solution.

Chiaroscuro
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.

mark007
7 - Meteor

Done 🙂

AnthonyPo
5 - Atom

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