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

Alex_Delgado
5 - Atom

Hi 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?

deviseetharaman
11 - Bolide
Spoiler
 
NapasornCh
7 - Meteor

Solved with simple sorting and multi-row formula logic with no macro needed.

Spoiler
NapasornCh_0-1590938622156.png

 

GeraldJTessier
8 - Asteroid

Here my result without macro

RogerWyllie
6 - Meteoroid

Managed to solve this using an iterative macro. Very interesting challenge! I have attached my macro and my workflow as separate files.

shadakht
6 - Meteoroid

Here is my solution.

AngelosPachis
16 - Nebula

Challenge #14 solved

 

Workflow : 

 

Spoiler
Annotation 2020-06-15 120922.png

 

Macro :

 

Spoiler
Annotation 2020-06-15 120727.png

 

FlorianC
Alteryx
Alteryx

I am not sure what the benefits of an iterative macro would be for such a process.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Soura
6 - Meteoroid

Hi,

 

I approached this frim non macro side and I didnt use multi row formula.

 

Only used running total and formulas.

 

Please find my solution attached.

FredNajjar
9 - Comet

I decided to go with the Macro solution. Since I never had to use macros in Alteryx, they are bloody annoying, especially debugging! 

 

Spoiler
Solution: 
Screenshot_12.png
Macro
Screenshot_13.png