Challenge #14: Warehouse Distribution

[Flo_P]

Spoiler

Solved with multi-row calculations, was less difficult than anticipated.

[eraaz_lala]

Hello,

Please find my solution to Challenge # 14

Regards, Eraaz

[BS_THE_ANALYST]

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]

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

Spoiler

[Zidi_Xu]

My first iterative macro!!

[bstonchu]

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]

my solution

[FinnCharlton]

Spoiler

[raghugange84]

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]

Spoiler