Congrats @SeanAdams on your new shiny badge!
Climbing to the summit alone however could lead to a dangerous selfie situation. Hopefully your team will catch you soon.
Thank you Mark!
I'm eagerly awaiting your 350 solutions milestone - that's the true definition of a peak that will be difficult for anyone else to scale! @MarqueeCrew
Not too long now until Inspire EU!
My approach. Since I wasn't able to jump on this quickly to win the first 75th badge, decided to take my time and work towards developing a Scrabble word app (which will let you include letters already on the board). Not there yet, but almost. Congratulations to everyone, with a special shout out to @SeanAdams, @NicoleJohnson, @LordNeilLord, and so many others who have contributed to our collective success in these challenges!!!!
Took a similar approach to many at the start, and then went a little macro-crazy. Started with cleaning up the word list to include words that are only 7 characters long (since the objective is a high scoring first word). Wrote the output to a yxdb for fastest processing.
Also cleaned up the letters/points/number tiles and wrote that output to a yxdb too.
Here's where I diverge. Then I designed a few macros:
This one generates all possible words from the letters in the hand:
This one generates point values per word:
This one generates possible words, taking into account one or two blank tiles:
And finally, my workflow that uses all of these macros:
Hopefully I packaged all of my macros with the workflow. When the app is finished, I'll post it too!
Not being a RegEx expert I wanted to figure out if I could do this the old-fashioned way: raw inexperience. And I did. This is, to an Alteryx Ace, probably an example of terribly inefficient workflow development. But what the hey? It works and I understand every step.
This doesn't run in sub-1 second times, either, but 1.4 seconds ain't bad.
The most fun was writing the step-by-step, letter-by-letter checks for each word between 2-7 letters long in the "Finding matches based on word length" Tool Container.
Alteryx is quite simply the most fun I've had coding in a long time.
That is a beautiful solution. Now, all we have to do is set up a secret data transmission system that can allow us to participate in and win the Scrabble world championships! Of course, I'm kidding because we are not cheaters, but I bet there are plenty of unscrupulous people out there that would love to take the chance. Thanks for sharing this because I really enjoyed the quality of the solution, the awesome documentation, and layout.