Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

qb
7 - Meteor

My 4th challenge. First time using spatial co-ordinates.

challenge-15.PNG

MartinStraech
8 - Asteroid

Ended up with same solution as posted. First time so far.

 

Spoiler
SolutionClipping.PNG
ocasey
6 - Meteoroid

I overlooked the find nearest tool, but I still achieved the same result. I've never used the spatial tools before--very cool!

RotesDB
8 - Asteroid
Spoiler
Challenge#15.png
DataKyle
8 - Asteroid

Its always fun to get to try out the spatial tools (currently don't have a need for it at my job).

 

Fun challenge

rcor
8 - Asteroid

Solved

 

Spoiler
challenge_15_RC_solution.PNG
Cumminsj2
7 - Meteor
 
Inactive User
Not applicable
Spoiler
Used Create Points to convert into points, then used FindNearest to find nearest points, joined with items assigned, multiplied and summarized.
DavidW
Alteryx Alumni (Retired)
Spoiler
Screenshot.png
David Wilcox
Senior Software Engineer
Alteryx
Reesetrain2
9 - Comet

All,

 

Spoiler
I decided to use the create points, find distance and then use summation and other tool from there vice using the nearest point tool.

-Nonetheless, you can use that tool.

Capture.PNG


-Cheers!

Matt