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

17 - Castor

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

Moderator

@patrick_digan - I can rest easy now!

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

Luke

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
15 - Aurora

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

Spoiler

Here's my workflow

EDIT:
Thanks to @patrick_digan I saw my mistake:

Spoiler
That minus sign makes a big difference:

10 - Fireball
Spoiler

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

5 - Atom

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

Spoiler
11 - Bolide

My Solution

8 - Asteroid

See you there!

7 - Meteor
Spoiler

Solved

6 - Meteoroid

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

Spoiler