Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #172: 2019 Grand Prix US - Heat 3

Highlighted
Alteryx Certified Partner

Here's my solution.

Thanks,

Chris

Highlighted
Alteryx Partner
Spoiler
172.PNG
Highlighted
Alteryx Partner

Figuring out how to group the items took a while.  Had to get help to figure out how to group the items so I could count the households in the contiguous area.  Definitely didn't finish before the checkered flag, but otherwise got it.

 

Spoiler
Process:
- Combine spatial objects
- Poly-split into regions
- Record ID for the 5 regions
- Spatial Match where individual blocks are in region (where target within universe)
- Count Households (group by RecordID)
- Divide number of Households by 160 (and roundup using Ceil function)
- Clean-up

MySolution.PNG
Highlighted
8 - Asteroid

Do not get the result at the first time. Refer to other's solution and learned two new tools: Poly Split and Make Group. Fantastic learn!

Spoiler
Annotation 2019-12-25 182647.png
Highlighted
8 - Asteroid
 
Highlighted
Alteryx
Alteryx

A good exercise... always like the spatial ones.

Spoiler
Snag_683a4a52.png

Snag_683a1fb7.png

 

Highlighted
7 - Meteor

My solution!

Highlighted
12 - Quasar

My solution:

 

Spoiler
Capture.JPG
Highlighted
8 - Asteroid

Took a while! 

Highlighted
8 - Asteroid