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.
Free Trial

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

Challenge #77: Extending Spatial Lines

JethroChen
10 - Fireball
Spoiler
challenge_77_jc.PNG
DataHabanero
9 - Comet

Awesome Possum!

AkimasaKajitani
17 - Castor
17 - Castor

Is this challenge is intermediate? I think that this challenge is advanced!

 

Spoiler
1.I made Big Circles whose radius is the Line length + 5miles.
2.I made Small Circles whose radius is the 6miles at each Line Edges.
3.I made the Crescents that are cut the Big Circles from the Small Circles.
4.I got centroids from the Crescents.
5.I made new lines the centroids.
6.I obtained the line with overlapping Big Circles and the New lines.

AkimasaKajitani_3-1599230575414.png

 

My Workflow & Macro

AkimasaKajitani_2-1599230187494.png

 


AkimasaKajitani_1-1599230160643.png

 

Result
AkimasaKajitani_0-1599230124798.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

gregchristensen
8 - Asteroid

I couldn't figure out the complete solution using just the Spatial Tools so I had to peek at the solution.  However, instead of just applying the same logic as the known solution, I used Spatial Tools to calculate the initial line lengths and direction in degrees, and calculated the extensions mathematically.

 

Spoiler
Challenge 77.png

 

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-11-16 à 15.27.21.png
Qiu
21 - Polaris
21 - Polaris

Very Good one!

Spoiler
en-77.PNG
Romy
7 - Meteor

My solution attached: 

 

Spoiler
2020-11-23 15_07_05-Alteryx Designer x64 - challenge 77 Macro.yxmc.png

 

JP_SDAK
8 - Asteroid

This was a tough one.  I ended up finding the bearing of the distance between start and end point of the original line. I  then created a trade area of the distance specified (default 5) around both the start and end point, split the trade area into points, then found the point on the opposite end of the trade area that matched the distance and bearing of both the start and end points.  Finally, I created a new line with the newly calculated start, end points.  I'm sure there was an easier way to do this, maybe with geometry formulas, but this seemed to work .

Spoiler
JP_SDAK_0-1606382442786.pngJP_SDAK_1-1606382459440.pngJP_SDAK_2-1606382530963.png

 

 

michael_leoni
8 - Asteroid

Pleas see my solution below.