Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
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.
Good exercise. Betting there are simpler ways, but I am learning more and more about spatial tools (no pun intended)
スポイラ
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
- 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
