Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# Weekly Challenge

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 #6: Spatial Route

8 - Asteroid

Nice and easy. Poly-build + Spatial Info and you got your answer.

8 - Asteroid

piece of cake

Spoiler

8 - Asteroid

solved

8 - Asteroid

My Solution

8 - Asteroid
Spoiler
Solution Attached!

I tried to solve this a couple ways to see how the Formula tool can be used as a one-stop shop for some spatial analyses:

6 - Meteoroid

My solution for the spatial route challenge - Calculating most miles.

17 - Castor

So, spatial not being my best suit I actually can't think of any other way I would have done this.

Spoiler
I first created a multirow formula which appended the centroid from above to the line below (grouped by REP) as the Origin city.
I then used the Distance tool to calculate the distance between origin and current city. I then summed by REP.
From the same multirow formula I then took another stream where I used the Poly-Build tool to create lines between the origin and current. Then I simply joined them back.

It was right so, yay me.

M.

8 - Asteroid
Spoiler

11 - Bolide

My solution.

Spoiler

8 - Asteroid
Spoiler