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.
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
Solved with multi-row calculations, was less difficult than anticipated.

8 - Asteroid

Hello,

Please find my solution to Challenge # 14

Regards, Eraaz

11 - Bolide

Both solutions included in file don't use macro, by the way.

Solution 1: The situation is: if a shop requires 50 items but we have less than that required amount in inventory left i.e. 30; I wouldn't supply any inventory to that shop. I imagined only half of my shopping arriving, I'd rather none of it turn up if that was the case 😂. I then tried to allocate that remaining inventory to other shops with less priority (if possible).

Solution 2: opposite to solution 1, if there was 30 inventory left and the shop requires 50. The shop will receive 30 inventory and have a demand not met of 20.

Now to try and learn how to do this with a macro! 😁

Spoiler

11 - Bolide

First time creating an iterative macro. Proud moment! Worth the time investment 👏

Spoiler

5 - Atom

My first iterative macro!!

5 - Atom

I didn't see the actual iterative solution posted, and I am super new at macros, so I attempted to find my own way to use an iterative macro here (although I think the non-macro solution is much faster and more straightforward)

It's not pretty, but it gets the job done :)

6 - Meteoroid

my solution

12 - Quasar
Spoiler

5 - Atom

Hi...Thank you for the various examples of Alteryx...I see for Challenge solution , you have uploaded challenge 11 solution....Can you please check and may be upload Macro solution

7 - Meteor
Spoiler