Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here265image.png

 

This week's challenge was submitted by @CharlieS - Thank you for your submission!

 

Each of the states in the USA have a proud history and unique culture. They also have unique two letter abbreviations. Inspired by this NPR Sunday Puzzle, use the two letter abbreviations from four states that border each other to create eight letter words.

 

One input contains spatial objects for each state and the other contains eight letter words. Find the possible combinations given the constraints above.

Aaron_Harter
11 - Bolide

@CharlieS Thank you for the challenge!

Spoiler
1.PNG

Batch Macro to identify bordering states:
265macro.PNG
Blake
12 - Quasar

Fun challenge on Monday morning! Good one, @CharlieS!

Spoiler
wc265.png
dsmdavid
11 - Bolide

Fun challenge. Got slightly different results (MOONLIKE? IL,MO,NE,OK; MAINLINE? IA,IL,MN,NE), not sure if I misunderstood it 😅

Spoiler

Overcomplicated it by using some prime list to compute anagrams

dsmdavid_1-1619447213118.pngdsmdavid_2-1619447286199.pngdsmdavid_0-1619448407136.png

 


dsmdavid_3-1619447389950.png

 

 


  

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
Not my prettiest work, and I didn't do the bonus challenge.
patrick_digan_0-1619449007073.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

I got the another result.

 

Spoiler
AkimasaKajitani_0-1619448797927.png

AkimasaKajitani_2-1619449257840.png

 



Some Words have multiple combinations.
AkimasaKajitani_1-1619449085922.png

 

 

apathetichell
19 - Altair
Spoiler
I thought about a macro for the spatial matches but went with 3 spatial match tools...
Spalders
8 - Asteroid
Spoiler
Spalders_0-1619455371861.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
265.jpg 
Matt_Pizzorusso
5 - Atom

Interesting Challenge!