Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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
dssnek
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