Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

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

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

Challenge #14: Warehouse Distribution

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

 

Highlighted
Alteryx Partner

solved without an iterative macro

Highlighted
7 - Meteor
Spoiler
Ivyin702_0-1586599032737.png

 

Highlighted
8 - Asteroid
Spoiler
igorp_0-1586622993121.png

 

Spoiler
igorp_1-1586623008085.png

 

Highlighted
7 - Meteor

Tried Iterative Macro first time

Spoiler
MOHAMMEDAFZAL_0-1586624434613.pngMOHAMMEDAFZAL_1-1586624460414.png

 

Highlighted
7 - Meteor

I used the running total approach for my solution.

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

Highlighted
Alteryx Partner

Done

Highlighted
5 - Atom

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