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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #265: Keep In Touch

AngelosPachis
15 - Aurora

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
13 - Pulsar
13 - Pulsar

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
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1619465409521.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1619467324438.png

 

phottovy
12 - Quasar

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
Alteryx

Solution attached!

TonyA
Alteryx
Alteryx

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
12 - Quasar

Interesting challenge but my result is a bit different.

 

Spoiler
キャプチャ.JPG
Ladarthure
13 - Pulsar
13 - Pulsar

Lovely challenge! Thanks @CharlieS for the challenge!

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1619513837737.png
kelvinlaw_1-1619513917780.png