Challenge #148: Rotating Century Puzzle

[NicoleJohnson]

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

[jezknee]

Solved!

[cplewis90]

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

[juansagasta]

Spoiler

[KlemensK]

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.

[RichoBsJ]

Hi @JoeM ! Here's my solution :)

Spoiler

[kelly_gilbert]

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:

[hfanda73]

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.

[Geoowl]

a rather inelegant solution, but a solution nonetheless!