community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #184: Closest Pubs to Tobacco Dock

Spoiler
SPOILER

184.png
Meteor
Spoiler
 I took the Alteryx Conference Location input, split it to rows and removed Leading/Trailing Whitespaces.  I then appended back the original location for kicks.  I did a right() function to pull the direction of the coordinate.  I then normalized the latitude or longitude by multiplying it by 1 or -1 for N,W and S,E.  I pivoted back on the original location and then created a point and then used the trade area to create a 1km circle (Everyone uses miles in England... Kilometers are all a lie!).  I created a point for each bar and, as they already were correctly formatted, used the spatial match to see where target records matched the trade area "universe".  I then grabbed the Ward maps and joined those to the returns to figure out that Greenwich is across the river (and where the English decided the Prime Meridian would run) from the conference.  I excluded all records in that ward and was left with 4 results.  I compared the distances and sorted (in Feet from the venue) the list of pubs.  Henley arms is your best bet at just under 3/10ths of a mile.  
Screen Shot 2019-10-07 at 4.05.58 PM.png
Alteryx Certified Partner

Fun challenge! The formatting in reporting tools always teaches me something new. Went for the original and advanced solutions - relying on the Distance tool to get the job done. Keen to see how others have approached the grouping across the river.

 

Spoiler
1.png

 
Original Solution
Snag_617a93a4.png
Advanced Solution
Snag_617b5aad.png

Pulsar

I love spatial challenges!!!

Spoiler
Basic approach: 
image.png

And advanced. Couldn't figure out how to get a shapefile of the area needed, so just traced using a map input. Then broke the pubs into north and south of the river. Find Nearest works to find the cardinal direction, and then a filter to separate north and south.

image.png

The workflow:

image.png

Most importantly, pub crawl at Inspire Europe?

 

Cheers!

Esther

Alteryx Certified Partner

Clean one and a small catcha on it as well if one is to quick.

 

Spoiler
weekly 184 done.pngWeekly 184weekly 184 Map.pngMap.
Bolide

My solution, spent most of the time trying to match the formatting of the map!

Alteryx
Alteryx

Map rendered with North and South of the river in pink and blue

For those coming to Inspire there are a few good pubs in that area. Notably The Town of Ramsgate and the Angel. Angel is up there with the best in London.

WC1842.PNG

 

Lost a fair bit of time on that advanced one, trying to create two separate shapes form the polygon and river line. Eventually realised there was a much neater way...

 

Spoiler
WC184.PNG

Great fun. See you all at Inspire!

 

 @JS420 interested to know how you created that polygon?

Alteryx
Alteryx
Spoiler
Capture.PNG

Alteryx Partner

Nice one!

 

Spoiler
Untitled.png
Asteroid

Nice one, looking forward to Inspire next week!

I did for only pubs on one side of the river which was a nice challenge

 

Spoiler
I got the Thames shapefile from here: https://www.ordnancesurvey.co.uk/
image.png

image.png