Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #133: US Grand Prix Prelims - NASA Location Analysis

Highlighted
13 - Pulsar
13 - Pulsar

I started this quite awhile ago before I really knew spatial tools.  Used it as practice to make a batch macro (create a table with all values), then never finished the workflow.  Picked it back up again now that I have studied the spatial tools and reworked to the finished solution.  I did get far enough with the macro solution that it would have given the same answer.

 

Spoiler
Workflow 133.JPG

 

Highlighted
Alteryx Certified Partner

Solution attached.

 

Spoiler
Challenge 133.PNG
Highlighted
11 - Bolide
Spoiler
Annotation 2019-11-07 145207.png
Highlighted
8 - Asteroid
Spoiler
challenge_133_solution_justindavis.PNG
Highlighted
8 - Asteroid

Thanks for practice exercise!

Highlighted
8 - Asteroid
Spoiler
2019-11-20 20_30_18-Greenshot.png
Highlighted
8 - Asteroid

Solution attached

Spoiler
18-12-2019 17-33-13.png
Highlighted
Alteryx Partner

Good exercise.  Betting there are simpler ways, but I am learning more and more about spatial tools (no pun intended)

 

Spoiler
Process:
- Calculate trade area
- Find Nearest tool to determine how many facilities within 200 miles of each facility
- Rank by facility with greatest FindNearestRank
- Select first record
- Append this facility to all others
- Calculate distance to each facility
- Sort by distance (asc)
- Filter out those more than 200 miles away (results include the target facility as well as the other 4)
- Poly-build tool to build convex hull on Source_Spatial Object


MySolution.PNG
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

My solution!