Challenge #6: Spatial Route

We hope you enjoyed last week's challenge. For the sixth challenge lets look at some of the geospatial capabilities in Alteryx.

The challenge for week 6 will focus on analyzing distance traveled by sales reps.

Sales reps are travelling all over the US. The data contained in the workflow details the travel paths for 7 Reps to 7 different cities. The travel route is detailed as well. The objective of this challenge is to determine which Rep has logged the most miles. Please include the route traveled as a spatial object in the output.

We have listed this as an intermediate challenge since not everyone is familiar with the Spatial tools. As always, we love to hear your comments. We hope you are having fun with the challenges!

challenge_6_solution.yxmd

challenge_6_start_file.yxmd

Spatial Analysis

Preparation

Advanced

Intermediate

Spatial

Accepted answers

All comments

samN

Was confused by the difference between output and input file times so solved two different ways to justify it to myself.

challenge_6_Two_Solutions.yxmd

Waynemk

i went with the multirow and then distance tool

challenge_6_waynek.yxmd

ggruccio

I've used spatial tools a ton, but first time to create a linear route!

challenge_6_gg_finish.yxmd

_sbeaumaster

A couple of ways to solve this one.

challenge_6_start_file_MySolution.yxmd

LandonG

Fun challenge!

Spoiler

challenge_6_start_file.yxmd

jasperlch

Solution attached.

challenge_6_JL.yxmd

aclaxton

This was my first time using the spatial tools and it was pleasantly intuitive!

Spoiler

Treyson

I took a little different route than the solution provided. I think that something must have changed in the spatial data because both my results and the solution results matched, but they were different than the miles in the output numbers in the challenge file.

challenge_6_TM.yxmd

MichaelKaloz

Huge benefit using the Multi-Row Formula tool!

challenge_6_start_file (20171214).yxmd

NurulShi12

First time using Spatial tools and my solution is not as simple and straightforward as the provided solution. Great practice definitely!

NS_Challenge 6.yxmd

blairmbailey

Solution attached - thanks!

challenge_6_BB.yxmd

michalsicak

slightly different results compared to the output required but the map browse shows the exact same routes so assume it's a glitch. posting my solution.

Spoiler

challenge_6_start_file.yxmd

SGolnik

This was fun because I've hardly looked at the Spatial tools. I had to do a lot of reading and playing!

challenge_6_mysolution.yxmd

derekbelyea

Spoiler

challenge_6_JDB_AnalytixStudio.yxmd

asabau

Here is the solution!

challenge_6_finished_file.yxmd

JosephSerpis

Challenge Completed

Challenge_6_Joe_Serpis.yxmd

Ukashi

Thank you for the challenge I've made it althought I got suspicion that my solution is not the most optimal one, so I've checked published solution. Anyway below is my solution with no correction as ugly as it is

Spoiler

challenge_6_solution Luke.yxmd

Caveman88

Challenge 6 complete!

Spoiler

challenge_6_solution.yxmd

sikel

Used formula tool rather than spatial info, but happy to know that exists now for next time!

challenge_6_start_file - DONE.yxmd

WLL

Completed

WLL_Challenge6.yxmd

AndyBate

after finishing a batch macro to do this i realised there is a much more 2 tool quicker option!!!! this is why i love and hate challenges

challenge_6.yxzp

CHarrison

Got frustrated when I couldn't get the values to match, but then I noticed the solution had the same output as my method, which is done slightly differently

Challenge 6.yxmd

luciebrett

Here is my attempt; using two new tools so a great task for spatial work!

challenge_6_LB.yxmd

remyagr

Attached is my solution

challenge_6_start_file_GR_Soln.yxmd

JaakkoS

My solution, had to learn the tools first. And I can't get an exact match with the two data sets.

challenge_6_solution_JWanhalinna.yxmd

maxjohnson02

Solution attached. My first instinct was to use a Cross Tab followed by a couple Spatial Functions, which was surprisingly simple. I was surprised to discover that the Spatial Tools made the solution even simpler.

challenge_6_start_file_MJ.yxmd

bdaniels

First time using the spatial tools

challenge_6_start_file.yxmd

adamp

Spoiler

for some reason yet to be determined my distance numbers don't exactly match the sample output provided even thought they are close and yield the same ranking.

challenge_6_work_file.yxmd

kelly_gilbert

Spoiler

My solution matches the posted solution file (9,077.8 miles), however, neither matches the output provided inside the file (9,182.9 miles).

challenge_6_solution_klg.yxmd

SimonaLoffredo

Here my solution for this challenge!

challenge_6_start_file.yxmd

ivoller

Took way longer than it needed to. I know what I need to study

challenge_6_start_file-ISV.yxmd