Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Flo_P
8 - Asteroid
Spoiler
Solved with multi-row calculations, was less difficult than anticipated.

Flo_P_0-1673604176461.png

 

eraaz_lala
8 - Asteroid

Hello,

Please find my solution to Challenge # 14

 

Regards, Eraaz

BS_THE_ANALYST
13 - Pulsar

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
BS_THE_ANALYST_0-1673979628128.png

 

BS_THE_ANALYST
13 - Pulsar

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

Spoiler
BS_THE_ANALYST_0-1674043071279.pngBS_THE_ANALYST_1-1674043098454.png

 

Zidi_Xu
5 - Atom

My first iterative macro!!

bstonchu
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 :)

Constance_Termoz
6 - Meteoroid

my solution

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1675430881227.pngFinnCharlton_1-1675430889081.png

 

 

raghugange84
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

JFarrierMa001
7 - Meteor
Spoiler
JFarrierMa001_0-1675779925886.pngJFarrierMa001_1-1675779937761.png