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.
Start 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 #172: 2019 Grand Prix US - Heat 3

ThomasHagen
メテオール
 
SeanAdams
17 - Castor
17 - Castor

Don't get to do too much spatial during normal use - so spatial challenges are always a fun change of pace.

Used the reporting tools to visualize the result.

 

Results.png

 

スポイラ

Recipe:
- Used a summarize tool to combine all into one polygon
- Then a polysplit to break into islands
- Then joined back to the original data to attach the Household details.   

I'm sure there's an easier way - gonna go back and check other people's solutions now.

FlowSolution.png

Update: 
- Never thought to use the MakeGroup like @Kenda  & @RolandSchubert & @neilgallen - I had stayed away from the spatial match because it seemed like we'd need to iterate dozens of times but this fixes the problem
- Same solution really as @NicoleJohnson@T_Willins

 
BTW - not sure if anyone noticed but @patrick_digan did this in horizontal mode - https://community.alteryx.com/t5/Weekly-Challenge/Challenge-172-2019-Grand-Prix-US-Heat-3/m-p/439273...    Is this the beginning of a new era for Digan, or perhaps just a momentary slip in focus?



TylerNa
ファイアボール

All three heats completed!

スポイラ
WC Grand Prix Heat3.JPG
afv2688
16 - Nebula
16 - Nebula

Nice one 🙂

 

スポイラ
untitiled1.png
Karam
アステロイド

Solution attached.

 

スポイラ
Challenge 172.PNG
timrains
アステロイド

Done. 

 

スポイラ
Week172.PNG
hanykowska
ボリード

I liked this one

 

スポイラ
image.png
OllieClarke
16 - Nebula
16 - Nebula

As always RTFQ

 

スポイラ
04:37
Challenge 172.png
ZenonH
アステロイド

Nashville was an experience I'll never forget, there's no way I could have come to this solution on stage. I remembered the solutions on stage using the make group tool, and I still had to research how to use it here. Looking forward to the next GP (:

スポイラ
ZHSOL.png

KeithZ
アステロイド
スポイラ
2019-11-11_20-22-32.png