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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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

Challenge #15: Warehouse Shipped Miles

Vishnu_Sekhar
7 - Meteor

Starting to learn spatial toolset. 

ARussell34
7 - Meteor

Here is my solution!

bam
7 - Meteor

.

Ywanggo
5 - Atom

My answer, basically is the same as the solutions.

euanwilson
8 - Asteroid

Another one bites the dust

 

Spoiler
First time playing about with spatial tools for this challenge. 
So to start off I joined the two data sets concerned with each individual store. I then used the Create Points tool to mark the points of each store coming out of the join and then another CreatePoints tool to mark each warehouse coming out of that input. 
Then the FindNearest tool was implemented with the store points going into the target input and the warehouse points going into the universe input with the maximum distance set at 100,000 miles. 
A simple formula to find the total miles was just the Distance in miles each item has to travel to get to the nearest store multiplied by the number of assigned items for that store. 
 Summarize tool to group by the Item and sum the total miles to calculate the total distance for each item. 
Select tool was then used to rename a column to match that of the given output. 

Workflow.PNGResults.PNG
JonServiceNow
7 - Meteor

First Spatial challenge for me. I liked this one a lot. 

paultno
8 - Asteroid

Here is mine.  Got confused at "assigned vs. required"...hope i wasn't the only one!

Ajjay
8 - Asteroid

soln

JasonTylerYoung
7 - Meteor
Spoiler
I enjoyed practicing with the find nearest tool, but I am not sure I understand the question being solved here.  The distance item 1 will need to travel could be expressed as the total distance of item 1 from each warehouse to each store, but it seems like the solution is actually tracking the total distance traveled for the full inventory of each item being shipped to each store - the number of "assigned" is the total inventory of an item to be shipped and we have to multiply assigned*distance to get the correct answer.  This seems like it is answering a question pertaining to shipping data (maybe to figure out total trucking or flight miles required for an inventory order to complete a cost calculation?) but its not entirely clear if that is the logic or not.  
jjrbondoc
7 - Meteor
Spoiler
jjrbondoc_0-1625502801768.png