community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #14: Warehouse Distribution

Fireball

Here is my solution :

 

Spoiler
I elected to used Multi-Row Tool rather than Macros to achieve this solution.

Challenge14.jpg

 EDIT

 

Decided to have a go at this challenge using a macro as well, and ended up using a Batch macro to solve it which worked out well.

 

Spoiler
Challenge14_macro.jpg
Asteroid

Package delivered. 

Spoiler
ZHSOL.png
Asteroid

Am I proud of it? No. Does it work? Yes. Should I try again with the macro approach? Probably...

Spoiler
challenge_14_solution_justindavis.PNG
Alteryx Partner

Pretty straight-forward this time (and I did a lot better than I did with the last warehouse problem faced)

 

Spoiler
Process:
- Join Store and Required data
- Sort results by Item then by Priority
- Join with warehouse Count in stock
- 1st Multi-Row tool groups by Item and decrements Count by amount required per store (but can't go below 0)
- 2nd Multi-Row tool groups by Item and calculates the Assigned amount which will equal Required, except
  -- If Count has decreased to 0, then Assigned is equal to Count of the prior row
- Clean-up data
- Sort by Store then by Item (both ascending)

MySolution.PNG
Asteroid

Challenge #14 Solved!

 

Spoiler
clipboard_image_0.png
Highlighted
Meteor
Spoiler
 

Boom.

Meteor
Spoiler
image.png
Asteroid
Spoiler
RLWK_14Macro.png
Spoiler
RL_wk_14workflow.png
Asteroid
 
Alteryx Partner

Previously here, missing the file.