community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #148: Rotating Century Puzzle

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

Alteryx Partner

Solved!

 
Fireball

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
Alteryx Partner
Spoiler
Spoiler.PNG
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.

Asteroid

Hi @JoeM ! Here's my solution :)

 

Spoiler
solution_148.PNG

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