Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #242: Meet Me Halfway

AYXAcademy
Alteryx
Alteryx

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

 

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.

Jonathan-Sherman
15 - Aurora
15 - Aurora

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
Jonathan-Sherman_0-1605537472762.png

 


 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1605535102464.png

 

neilgallen
12 - Quasar
Spoiler
Screenshot 2020-11-16 090107.png
Aaron_Harter
11 - Bolide

So many beautiful cities & regions to visit!

Spoiler
242.2.PNG

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

Spoiler

 

dsmdavid
11 - Bolide

 

Spoiler
dsmdavid_0-1605536130211.png
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.

NS4
7 - Meteor
Spoiler
Capture.PNG

Blake
12 - Quasar

Fun spatial challenge!

 

Spoiler
wc242.png
paulfound
11 - Bolide
Spoiler
PaulFound_0-1605538022115.png

 

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

DeanWest
9 - Comet

Great challenge to start the week!

 

Spoiler
challenge_242_solution-DeanWest_snippet.png

 

Spoiler
Did anyone else notice that the point created for Broomfield is in California?
challenge_242_solution-DeanWest_snippet-2.png