Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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

Highlighted
8 - Asteroid
8 - Asteroid

@FredNajjar how annoying? 😄

Highlighted

Posting my first solution to a weekly challenge! Had to think about the conditional logic for the formula tool for a little while, but finally figured it out!

weekly14wfpic.PNG

 

Highlighted
8 - Asteroid

I'm much better at batch macros so this was a good challenge to refine some other skills.

Highlighted
6 - Meteoroid

My monster of an inefficient process to get to the answer. 

Highlighted

few steps

Highlighted
6 - Meteoroid

A bit challenging but fun 

Here is my solution, i've used an Iterative macro to practice my macro skills 

 

The Workflow : 

Spoiler
Capture_Workflow.PNG

 

The Macro : 

Spoiler
Capture_Macro_Workflow.PNG

 

Highlighted
8 - Asteroid

Here's my solution (without using macro)

Highlighted
8 - Asteroid

Here is my non macro solution 

Highlighted
8 - Asteroid

Straightforward multi-row problem. For a moment I was worried priorities were be store AND item, but fortunately not.

Spoiler
Tberney_0-1595449092754.png

 

Highlighted
Alteryx
Alteryx

Here is my solution, using basic tools:

 

Spoiler
KilianL_0-1595575674930.png