Challenge #242: Meet Me Halfway

A solution to last week's challenge can be found here.

One day it will be nice to travel again. When that day comes, efficiency won't be on many people's minds, but we can dream...

This week's challenge is to find the most central office location to meet up, given a list of cities in which Alteryx has offices. The dataset contains the City, Region, and coordinates of the cities. Your task is to determine the city that is most central for each region, then calculate the distance from each of the other cities in that region to that city.

challenge_242_start_file.yxmd

challenge_242_solution.yxmd

Parse

Spatial Analysis

Preparation

Advanced

Intermediate

Transform

Spatial

Accepted answers

All comments

Jonathan-Sherman

Challenge 242 is done! The sort was only to get records in the exact order as the challenge output so technically managed a 4 tool solution!

Spoiler

challenge_242_JMS_solution.yxmd

patrick_digan

Spoiler

challenge_242_start_file.yxmd

neilgallen

Spoiler

challenge_242_NGA.yxmd

Aaron_Harter

So many beautiful cities & regions to visit!

Spoiler

(edit 11/16 10:00 CT) video of solution overview:

Spoiler

challenge_242_AB Data_Aaron.yxmd

dsmdavid

Spoiler

Was trying to plot a map, but got an error:
\AppData\Local\Alteryx\bin\RuntimeData\MapServer/Default.map: MapServerError - Routine:msProcessProjection() Message:proj error "no system list, errno: 2
" for "init=epsg:900913" Code:11 ??

oh well, just the table then.

david_242.yxmd

NS4

Spoiler

Blake

Fun spatial challenge!

Spoiler

challenge_242_start_file_BH.yxmd

paulfound

Spoiler

Wow, wasn't expecting that to be that simple! Good job Alteryx!

challenge_242_pf.yxmd

DeanWest

Great challenge to start the week!

Spoiler

Did anyone else notice that the point created for Broomfield is in California?

challenge_242_solution-DeanWest.yxmd

AkimasaKajitani

My solution.

Spoiler

challenge_242_start_file_AK.yxmd

RolandSchubert

Spoiler

challenge_242_solution_rsc.yxmd

OllieClarke

Here's my solution:

Spoiler

challenge_242_OC_solution.yxmd

DaisukeTsuchiya

Interesting challenge!

Spoiler

challenge_242_start_file_DT.yxmd

Sashikumar

Good one.

Spoiler

challenge_242_start_file_sk.yxmd

sara_burk

Spoiler

Love spatial challenges!

challenge_242_SB.yxmd

phottovy

Anyone else notice that the coordinates of Irvine and Broomfield seem to be swapped?

Spoiler

challenge_242_ph_solution.yxmd

Spalders

Spoiler

Jonathan-Sherman - important to get Target and Universe set correctly for the Find distance tool once the regional centers have been established using the Summarise tool.

challenge_242_ADS.yxzp

hanykowska

Nice one

Spoiler

challenge_242_solution_hanykowska.yxmd

Raj_Singh1

Hi,

Please see my solution attached. 🙂

Spoiler

challenge_242_Solution_Raj_Singh.yxmd

SeanAdams

Did this a kinda long way - now I need to go back and understand some of the other people's solutions like @Jonathan-Sherman 's elegant solution

Spoiler

challenge_242_SeanAdams_Solution2.yxmd

AngelosPachis

My solution for challenge #242

Spoiler

challenge_242_solved_AP.yxmd

abrouwer

Spoiler

challenge_242_solution_file - AJB.yxmd

Iclicker2020

First Challenge Completed

challenge_242_start_file (1).yxmd

collinalldata

Probably didn't need to use a macro for this but ¯\_(ツ)_/¯

challenge_242_collin.yxzp

ehughes

My solution

Spoiler

challenge_242_start_file.yxmd

NZP

Spatial is definitely not a strong suit for me.

challenge_242_nzp_file.yxzp

LHolmes

Terrific spatial challenge with some data parsing. Went the extra mile and created maps for each of the regions.

Spoiler

challenge_242_solution_lmh.yxmd

RichoBsJ

Hi! Nice challenge! 🙂

Spoiler

challenge_242_richobsj.yxmd

mbogusz

Spoiler

.yxmd

.yxmc

I used a batch macro to do the spatial processing by region and it worked just right

challenge_242_solution_mbogusz.yxzp

KaneG

I couldn't decide which way I wanted to go and so I went with a couple.

Spoiler

The first one finds the centroid for each region and then finds the nearest office to that. This is quick, but does it definitely minimise distance? So the second one actually does the calcs on the distance to work out the min.

challenge_242_Completed-KG.yxmd

ACW

Learned something new, group by region and create centroid, that reduced the steps needed to knock out the task. thx!

jduracka

Spoiler

challenge_242_solution_clean.yxmd

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335