In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #265: Keep In Touch

AngelosPachis
16 - Nebula

Nice one for this week. Managed to get there without a macro and I'm sure that there is a way to reduce the number of joins, but happy with it in overall 😀

 

Workflow

Spoiler
AngelosPachis_1-1619459602395.png

 

Heatmap

 

Spoiler
AngelosPachis_0-1619458944565.png

 

OllieClarke
16 - Nebula
16 - Nebula

Fun Challenge 🙂 

Spoiler
OllieClarke_0-1619461295813.png

I found that 4 words could be made with more than 1 combination of contiguous states (e.g. CONDEMNS - CO,MN,NE,SD or CO,NE,NM,SD) so I included all combinations in my answer.

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1619465409521.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1619467324438.png

 

phottovy
13 - Pulsar
13 - Pulsar

Similar to others, I found several other words as well as several state combos that cover certain words:

 

Spoiler
265.PNG
HeatMap.png
cchandler21
Alteryx Alumni (Retired)

Solution attached!

TonyA
Alteryx Alumni (Retired)

Similar to others, I found multiple combinations of states that could cover some of the words. In particular, MN, IA, NE, and CO, have the same letters as IA, NE, CO, and NM. 

Spoiler
TonyA_0-1619487208649.png

 

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar

Interesting challenge but my result is a bit different.

 

Spoiler
キャプチャ.JPG
Ladarthure
14 - Magnetar
14 - Magnetar

Lovely challenge! Thanks @CharlieS for the challenge!

kelvin_law1
9 - Comet

Here is my solution:

Spoiler
kelvinlaw_0-1619513837737.png
kelvinlaw_1-1619513917780.png