alteryx Community

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.

Challenge #265: Keep In Touch

Alteryx

A solution to last week's challenge can be found here

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.

11 - Bolide

@CharlieS Thank you for the challenge!

Spoiler

Batch Macro to identify bordering states:
12 - Quasar

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

Spoiler
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

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

17 - Castor

My solution.

I got the another result.

Spoiler

Some Words have multiple combinations.

18 - Pollux
Spoiler
I thought about a macro for the spatial matches but went with 3 spatial match tools...
8 - Asteroid
Spoiler

16 - Nebula
Spoiler

5 - Atom

Interesting Challenge!