cancel
Showing results for
Did you mean:

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

## Challenge #148: Rotating Century Puzzle

Magnetar

This is the second time I've seen this problem... and alas, it was no easier the second time. This one definitely had my brain rotating!

Spoiler
For this workflow, I approached it with the mindset of trying to figure out the "future state" of each position combination that gave me 100... and then joining back to the original data to see if those future states existed. If it exists 6 times in the data, for each of the 6 possible positions, then those records are the winners!

I LOVE LOVE LOVE these puzzle/game type challenges. So cool to see the creative ways that Alteryx can extend beyond just the day-to-day job (even if the day-to-day job also feels quite a bit like playing a game most days!)

Thanks for the super-fun-but-also-crazy-mind-bending challenge, @JoeM  @patrick_digan  @brianaburke002 @DultonM !

Cheers,

NJ

Alteryx Partner

Solved!

Atom

Bolide

This was a definite challenge and require some research on some formulas, but once I learned about a few new ones, I was really able to get through this one.

Spoiler
Alteryx Partner
Spoiler
Meteoroid
Spoiler

After using Alteryx for like a week i wanted to try something different then my normal data and these puzzles are pretty fun to play around with and learn something new by doing them.

But after looking at the other solutions i have to say that i should better learn all the Tools that are available instead of using 4 Tools for a function that one can do.

Asteroid

Hi @JoeM ! Here's my solution :)

Spoiler

Bolide
Spoiler
This is pretty inefficient. Perhaps iterating through the solutions with a macro, where you could "throw out" the invalid solutions as you go along would be better... However, I really wanted to figure this out using formulas!

Continued to the right...

Detail of formula tool:
Asteroid

Posted my first weekly challenge solution. It took me a while to do this as there were many options.

Hope to catch up with others.

Meteor

a rather inelegant solution, but a solution nonetheless!