Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #184: Closest Pubs to Tobacco Dock

Highlighted
16 - Nebula
16 - Nebula

@LukeM For what it's worth, I've used the buffer tool in the past to turn the line into a really thin polygon. Then you can use the spatial process to remove the line from the trade area and then poly split to split the 2 separate parts into their own rows. Your solution is simpler, but this method will return the 2 separate pieces of the polygon which is sometimes useful.

Annotation 2019-10-09 081812.jpg

Highlighted
Alteryx
Alteryx

@patrick_digan - I can rest easy now!

 

That's the solution I was looking for. Cheers for that, much appreciated.

clipboard_image_0.gif

 

Luke

Highlighted
8 - Asteroid

I opted to find the nearest bar on the other side of the river as the crow flies. Shame I don't have Tom Tom, because it would be a shorter stumble home from the Mayflower than the Angel, unless you fancy a swim. 

Spoiler
ZHSOL.png
Highlighted
Alteryx Certified Partner

I don't think I've ever got a reporting tool correct on first attempt

Spoiler
clipboard_image_0.png


Here's my workflow
Challenge 184.png

EDIT:
Thanks to @patrick_digan I saw my mistake:

 

Spoiler
That minus sign makes a big difference:
clipboard_image_0.png

 

 

Highlighted
Alteryx Certified Partner
Spoiler
Capture.PNG

Map Input ftw. Now if you excuse me, I'll be back to studying for my two exams.

Highlighted
5 - Atom

text functions, create points, create trade area, spatial match

Spoiler
clipboard_image_0.png
Highlighted
Alteryx Partner

My Solution

Highlighted
8 - Asteroid

See you there!

Highlighted
7 - Meteor
Spoiler
clipboard_image_0.png

Solved

Highlighted
6 - Meteoroid

First time posting a solution. Always enjoy staying sharp with the spatial tools (and how to replicate with formulas).

Spoiler
clipboard_image_1.png