Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
15 - Aurora
15 - Aurora

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

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