Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
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 #77: Extending Spatial Lines

11 - Bolide

That was fun!

Spoiler
16 - Nebula

My solution using the Trade Area approach

11 - Bolide

I could really use some tutoring regarding trigonometry...

Here's the macro I produced:

Spoiler
9 - Comet

9 - Comet

This was a bit of a head scratcher at first. I though there may be some clever way of using the spatial tools to extend the lines - and then thought that maybe Mr Pythagoras could help - which he didn't (Long and Lat are not the same unit of measurement). Eventually I decided on a solution that simply used a ratio to extend the points 5 miles in the correct direction - which turned out to be a very simple workflow in the end.

Spoiler

Using coordinates for the vertices of the bounding rectangle for each line I could calculate the adjustment for the start and end points and apply it to create the new start and end points.

8 - Asteroid

Spoiler

Didn't use a macro to complete. Used angle to determine new points which makes the answer just barely off.

14 - Magnetar

Similar to approach to what most others seem to have achieved by doing the 'lollipop' approach.

Spoiler
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
8 - Asteroid

Here is my solution!

15 - Aurora

Challenge 77 is done!

Spoiler

Alteryx

Took a flight, some noodling and getting stuck in Newark airport to finally get this one across the finish line.

Spoiler