alteryx Community

# 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.

## Challenge #184: Closest Pubs to Tobacco Dock

8 - Asteroid

I couldn't help but chuckle reading through the thread at how everyone else did the river split using fancy spatial tools. I just used the data provided, added some context from the real world, and got the task finished quick so I can get out from behind the keyboard and into a pub!

Spoiler
Nice one, pretty straight forward. Parsed the lat/long points and then buffered the 1km radius. Did a spatial match for the in/out pubs then used the Borough name in the Map Report tool to categorize the results into north and south of the River Thames.

14 - Magnetar

Does anyone have a list of pubs for New Orleans?  I'd like to plan for next June...

6 - Meteoroid

Seems that the solution was with distance < 1mile, this was my first challenge, very interesting and useful for my job

8 - Asteroid

I don't normally post my answers to these but I thought this one might be of some use to someone. I decided to have a go a building a custom polygon that intersected the Thames and took only the bit north of the river. Hopefully there is an easier way of doing this than my method! Looking forward to rolling that out as a question to my tutor in the spatial analytics class at inspire.

7 - Meteor
Spoiler

8 - Asteroid

A slightly easier way of creating the custom polygon

Alteryx

Solution attached, thrown of by changing the co-ordinates of the West value

11 - Bolide

My solution 🙂

Spoiler
13 - Pulsar

My solution:

Spoiler
5 - Atom

Here's my solution:

Spoiler
Spoiler
I initially was working on filtering out the points south of the river with spatial tools but realized I could accomplish that by filtering out the borough of Southwark instead.