Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
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.
SUBMIT YOUR IDEA
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.
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.
Didn't use a macro to complete. Used angle to determine new points which makes the answer just barely off.
