Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# 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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #148: Rotating Century Puzzle

6 - Meteoroid

18 - Pollux

Good puzzle.  It must take forever in physical form...you're carefully working your way through the combinations...and then your little brother comes along and spins the little wheels!  Doh!

Spoiler

Dan

8 - Asteroid

For me the really tricky part was defining what combinations were tied to each other (i.e. if axis 1 is using a value on a certain wheel, then the axis to its right would necessarily be using the value to the right on that same wheel, etc.) and then keeping track of that ... finally got that to work.  :0)

Take a look (if you are having trouble on how to start - this may help because I always use lots of notes and descriptive labels)

:-)

8 - Asteroid

fun - solved without a macro - I can't imagine doing this actual puzzle as I found there were 650 combinations that added up to 100!

Spoiler
my solution is a bit of a kludge/brute force - I created the string of all the options by creating numerical records from 111111 to 666666 and converted them to string.  Next I used regex to remove any records with a number not between 1 and 6 and then tokenized it to get each position in a column.  I then joined it all together, filtered on rows that summed to 100 and then looked for other rows that were the next sequence in line.

13 - Pulsar

Kudos to @patrick_digan@brianaburke002, and @DultonM for authoring this awesome challenge!

This one really stretched my brain, and it was a lot of fun to solve!

My solution:

Spoiler
16 - Nebula

Flexing the ol' Python skillz...

Spoiler
Python NotebookWorkflow
11 - Bolide

Had to have this done before next week, if I need to keep up with the pace.

I am not proud of this, I kind of had to brute force my solution, but after a while , I did get the result.

Spoiler

When I afterwards look at how others had solve it, I saw some that basically did the same, but it a much smarter way 😍

Until next week, have a nice weekend

/Thomas

13 - Pulsar

I used iterative macro method to solve this puzzle.  Received 194 different combination of output.

Spoiler

17 - Castor

Thanks for letting us challenge the community @JoeM! Here is my solution:

Spoiler
12 - Quasar

I really wanted to solve this mathematically but when staring at the pattern didn't work, I had to go macro. Edit: Basically like @jdunkerley79 did. That was the elegance I was originally going for. Nice work!!

Spoiler
append all files firstiterative macro

@danilang - I'm back :) :)