topic Re: Challenge #184: Closest Pubs to Tobacco Dock in Weekly Challenges

Challenge #184: Closest Pubs to Tobacco Dock

ChristineB — Tue, 13 Sep 2022 15:09:17 GMT

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

Are you going to Inspire London? So are we, and we couldn't be more excited! Between two full days of Platform Training, a variety of breakout sessions, keynotes, and (our fave!) THE GRAND PRIX, we are ready to get.amplified!

Surely, all this activity will make us pretty thirsty. In preparation for Inspire, complete this week's challenge to map out the nearest pubs to Tobacco Dock where we can grab a pint with fellow Alteryx aficionados.

Re: Challenge #184: Closest Pubs to Tobacco Dock

JORGE4900 — Mon, 07 Oct 2019 16:44:05 GMT

Break up lat lon into two fields; create points, create trade area, and spatial match. Looks like 4 Pubs within 1 km.

Re: Challenge #184: Closest Pubs to Tobacco Dock

JordyMicheal — Mon, 07 Oct 2019 16:53:48 GMT

Same as others it seems. Fun little one

Re: Challenge #184: Closest Pubs to Tobacco Dock

LukeG — Mon, 07 Oct 2019 17:09:17 GMT

Used Spatial Match and Find Nearest to get same solution

Re: Challenge #184: Closest Pubs to Tobacco Dock

patrick_digan — Mon, 07 Oct 2019 17:11:02 GMT

1) I didn't realize that I had to use a negative on the x value to get the right spot.
2) I think this is a great use of custom map icons

Re: Challenge #184: Closest Pubs to Tobacco Dock

viveknshah — Mon, 07 Oct 2019 17:16:19 GMT

Hopefully I met the ROYAL STANDARD! , else probably just REACH out my HENLEY ARMS upto BRICK LANE BREWS

Re: Challenge #184: Closest Pubs to Tobacco Dock

TonyA — Tue, 08 Oct 2019 15:28:56 GMT

Fun challenge. Too bad I can't get to Inspire and check the dock out in person...

I got caught by the "W" on the longitude and forgot to change the sign. The solution set me straight...

Added a solution to finding all the pubs on the same side of the Thames. It's not pretty and has some limitations but it's the best I could come up with. Looking forward to seeing others' solutions.

EDIT: Added a second version of the solution that doesn't have the limitations of the first one

Re: Challenge #184: Closest Pubs to Tobacco Dock

viveknshah — Mon, 07 Oct 2019 17:26:09 GMT

Learnt I made a blooper thanks to patrick_digan , My first spatial attempt and the learning continues!

Re: Challenge #184: Closest Pubs to Tobacco Dock

danilang — Mon, 07 Oct 2019 17:31:19 GMT

As it should be...32 pubs within one KM. I'm kinda' wary about the Slug and Lettuce, though.

Split lat/lon and change the lon to - since it's W. Find nearest within 1KM and spend some quality time in the Map tool to get icons.

Dan

Re: Challenge #184: Closest Pubs to Tobacco Dock

Kenda — Mon, 07 Oct 2019 17:36:01 GMT

I don't work with Lat/Long very often, let alone with London addresses, but I quickly learned that W meant to multiply that number by -1 based on the given output.

I wonder how many of these pubs @BenMoss has been to...

Re: Challenge #184: Closest Pubs to Tobacco Dock

T_Willins — Mon, 07 Oct 2019 17:49:53 GMT

Regular and advanced.

Re: Challenge #184: Closest Pubs to Tobacco Dock

JORGE4900 — Mon, 07 Oct 2019 18:01:24 GMT

Nice solution @patrick_digan You were able to figure out the longitude needed to be negative; I also like the way you came up with the icons for the pubs

Re: Challenge #184: Closest Pubs to Tobacco Dock

Adam_Dooley — Mon, 07 Oct 2019 18:08:48 GMT

That Report Map tool is neat! Something I need to mess around more with.

Re: Challenge #184: Closest Pubs to Tobacco Dock

JORGE4900 — Mon, 07 Oct 2019 18:20:41 GMT

Nice job creating that polygon @T_Willins and cutting it out from the trade area.

Re: Challenge #184: Closest Pubs to Tobacco Dock

RolandSchubert — Mon, 07 Oct 2019 19:12:48 GMT

Excellent preparation for Inspire.

Create Points and Find Nearest did the job, Report Map to show trhe results

Re: Challenge #184: Closest Pubs to Tobacco Dock

kmcdaniel — Wed, 09 Oct 2019 14:56:29 GMT

Re: Challenge #184: Closest Pubs to Tobacco Dock

JosephSerpis — Mon, 07 Oct 2019 21:08:55 GMT

Challenge Completed. I went for the advanced challenge and isolated the pubs from the South of the river using a technique called Voronoi polygons which @timrains showed me how to do within Alteryx.

Re: Challenge #184: Closest Pubs to Tobacco Dock

hbraunius — Mon, 07 Oct 2019 21:16:34 GMT

My solution attached.

Re: Challenge #184: Closest Pubs to Tobacco Dock

RoDO — Mon, 07 Oct 2019 21:41:04 GMT

My solution

Re: Challenge #184: Closest Pubs to Tobacco Dock

CharlieS — Wed, 09 Oct 2019 14:01:58 GMT

Answering the real questions here.