Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi Alex! What if we add an extra Ware House to the input, do we are forced to use iterative macro in order to update two different inputs (simultaneously), the remaining inventory of each ware house and the demand of each store?
Solved with simple sorting and multi-row formula logic with no macro needed.
I am not sure what the benefits of an iterative macro would be for such a process.
I decided to go with the Macro solution. Since I never had to use macros in Alteryx, they are bloody annoying, especially debugging!