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 #15: Warehouse Shipped Miles

ClintonF
Alteryx
Alteryx
Spoiler
Spoiler
challenge_15_CF.JPG
Clinton Fisher
Manager, Customer Success Management
Alteryx, Inc.

Filclarke
6 - Meteoroid

Solution Attached, thanks

rayJ
8 - Asteroid

Straight forward practice for spatial tools. Great for prepping for the advanced exam

Spoiler
rayJ_0-1601438115263.png

 

DaisyJones
8 - Asteroid

My Solution, seems to be the same as most of the solutions

 

Spoiler
#15.png

LGFAnalyst
6 - Meteoroid

I had never used the spatial features before, crazy to think how easy it is to calculate the nearest point with this. 

jgosalia
7 - Meteor

Spoiler

Sashikumar
8 - Asteroid

Good.

Spoiler
ch15.PNG
rajatsadan
8 - Asteroid

@GeneR Interesting challenge!! However, having a query regarding the final solution. Much appreciate if anyone could help out 

Spoiler
I have used multiple combination of joins to create every combination of possible shipment and derive the MIN for each item for each store through SUMMARIZE. There is a slight variation in my solution from the final output solution provided. Could you kindly let me know where I went wrong??  I was not aware of the FIND NEAREST Tool, that's why I proceeded with JOINS. 
A2H
11 - Bolide

This is my solution. Thanks.

stellarstevey
7 - Meteor

This was the first time I've used the spatial tools. Pretty cool.