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.

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

RichoBsJ
10 - Fireball

Hi! My solution 🙂

 

There aren't 36 rows in the solution, there are actually 42 rows, because NM & MN states are creating some duplicated words...

 

BTW, it only took 47 seconds to run 😉

 

Spoiler
Workflow:

WORKFLOW 265.jpg

Results detail:

CHALLENGE265.jpg

 

Qiu
17 - Castor

It is been a while to have Spatial one.

Spoiler
challenge_265.PNG
lucia_haswell
6 - Meteoroid

getting different words, does anyone know why?

KaneG
Alteryx
Alteryx

Cool problem to solve. I only used one spatial tool in the whole thing (1 x Spatial Match) and I got 40 words.

 

A couple of them are repeats though which makes sense using Alabama instead of Louisiana and New Mexico instead of Minnesota. The repeats are Condemns, Makimono, Matronal, Monecian. If the technique used was the other way around to look at the words then see if that word could be made, then those duplicates may not have been found. 

 

Spoiler

My Workflow:

KaneG_0-1620622961213.png

Essentially, I constructed every combination of 4 touching states and then sorted the letters alphabetically and compared those to the word list (sorted alphabetically).

JonathanAllenby
8 - Asteroid

I spent way too long on this.

 

Spoiler

My iterative macro first finds all pairwise touching states on the first pass, and subsequently drops the shapes and keeps finding the subsequent connected states using the pairwise combinations. Keeping the shapes really blows up the workflow and grinds it to a halt. I also gave the macro user the option of increasing the number of connected states, for the hypothetical situation where you had a list of 10 letter words, or 12, etc.

JonathanAllenby_0-1620749644959.png
JonathanAllenby_3-1620749833057.png

 

FlorianC
Alteryx
Alteryx

Maps are always a challenge.

 

Spoiler
workflow.png
Florian Carrier
Senior Solution Engineer
Alteryx
LHolmes
9 - Comet

Super challenge! Was fun to use quite an array of tool palettes.

 

Spoiler
265 - Solution.PNG
265 - Result.PNG
265 - Map.PNG
aruiz-itp
11 - Bolide

her is the solution

Jonny
11 - Bolide

Nice one. I think I got to a simpler approach to identify words that are made by NM & MN.

ggruccio
13 - Pulsar
13 - Pulsar

Fun challenge!

 

Spoiler
For any challenge that compares letters in words, I always alphabetize the letters in both matching inputs then see what joins.  I used spatial match tool to see which states border one another, ensuring all 4 states were unique abbreviations.