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

lainecaruzca
8 - Asteroid

my solution

MikeLR
8 - Asteroid

That took some time and thinking!

Spoiler
MikeLR_0-1604946813911.png

 

JP_SDAK
8 - Asteroid

This probably lended itself to an iterative macro, but I did it the brute force way instead since still getting the hang of macros.  I sorted by item and priority,grouped by item, and then started subtracting from inventory for each item.  To calculate assigned- if inventory was still positive or 0, then it was equal to required. Elseif abs(inventory) > required, then 0, otherwise required+inventory to get the amount fulfilled.

Spoiler
Spoiler
JP_SDAK_0-1605112380125.png

 

bkwilson
7 - Meteor

Back at it to try and get my advanced cert! This took me forever to figure out... Managed it with the iterative macro in the end!!

 

Spoiler
ch14.PNGch14m.PNG
DN
8 - Asteroid
Spoiler
Capture.PNG

enwiegand
7 - Meteor

Macro didn't really make sense to me either... 

 

enwiegand_0-1606275447800.png

 

Romy
7 - Meteor

My non-macro solution for this problem:

 

Spoiler
2020-11-25 18_36_24-Alteryx Designer x64 - challenge_14_start_file_romy.yxmd_.png

 

enwiegand
7 - Meteor

Slept on it and the macro came to me in my dreams😃

JBraithwaite
8 - Asteroid

My solution

NikitaParab
8 - Asteroid

Tried it without Macro

Spoiler
NikitaParab_0-1606733314288.png