Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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! 😁
First time creating an iterative macro. Proud moment! Worth the time investment 👏
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 :)
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