Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #148: Rotating Century Puzzle

Highlighted
14 - Magnetar
14 - 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!

WeeklyChallenge148.JPG

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

Highlighted
Alteryx Partner

Solved!

Highlighted
5 - Atom
 
Highlighted
12 - Quasar
12 - Quasar

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
Challenge 148.PNG
Highlighted
Alteryx Partner
Spoiler
Spoiler.PNG
Highlighted
6 - Meteoroid
Spoiler
148.PNG

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.

Highlighted
8 - Asteroid

Hi @JoeM ! Here's my solution 🙂

 

Spoiler
solution_148.PNG

challenge_148.PNG
Highlighted
11 - 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!


challenge_148_p1.PNG


Continued to the right...
challenge_148_p2.PNG

Detail of formula tool:
challenge_148_calcs.PNG
Highlighted
8 - 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.

Highlighted
7 - Meteor

a rather inelegant solution, but a solution nonetheless!