Output
Input
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #75
Harder - 1 Blank
Hardest - 2 Blanks
C:\Users\sjohnson\AppData\Local\Temp\Engine_6448_cae0f233025048e89427f8ba77f10948_\Engine_4796_a9cd5d85301e47b088efe37ad024c68f_.yxdb
Single
Profile
b,a,o,blank,t,q,u
C:\Users\sjohnson\AppData\Local\Temp\Engine_6448_cae0f233025048e89427f8ba77f10948_\Engine_4796_4530a8cefb5b47dea9d64324d87c586e_.yxdb
Single
Profile
v,q,t,r,blank,blank,p
C:\Users\sjohnson\AppData\Local\Temp\Engine_6448_cae0f233025048e89427f8ba77f10948_\Engine_4796_67544fc393094431b01395b001f4bc3e_.yxdb
Single
Profile
e,d,g,c,r,a,l
Letters in hand
cadger
10
e,d,g,c,r,a,l
graced
10
e,d,g,c,r,a,l
cadge
9
e,d,g,c,r,a,l
caged
9
e,d,g,c,r,a,l
cradle
9
e,d,g,c,r,a,l
C:\Users\sjohnson\Stuff\Programming\Alteryx\words.txt
28591
\s
False
254
False
False
DoubleQuotes
1
words.txt
Simple
Too_Long
=
No
[Too_Long] = "No"
Create a Too Long column measuring word length
7, "Yes", "No")
]]>
C:\Users\sjohnson\Stuff\Programming\Alteryx\lettervalues_cols.txt
28591
\s
False
254
False
False
DoubleQuotes
1
lettervalues_cols.txt
Only keep the words that are 7 letters or less
Parse each word into by-letter columns
First_Letter = Left([Field_1], 1)
Second_Letter = Substring([Field_1], 1, 1)
Thi...
Merge the parsed word columns with each word's score
Hand
Last
Hand
Split letters in hand into columns
Warn
Transpose columns into single column
Sort letters into ascending order
Value - Ascending
,
Cross-tab the letters in hand back into columns
Drop the original column and rename the letters in hand columns
Error
Append the New Hand column to each word row and rename back to Hand
Is the first letter of the word in our hand?
FirstLetter_Match = IF Contains([Hand], [First_Letter]) THEN "Yes" ELSE "No" END...
Create the New Hand by combining the original letters in hand to a single string
New_Hand = [Hand_Letter1] + [Hand_Letter2] + [Hand_Letter3] + [Hand_Letter4] + [...
Word_Score - Descending
C:\Users\sjohnson\AppData\Local\Temp\Engine_6448_cae0f233025048e89427f8ba77f10948_\Engine_4796_1be44d91e85e402f8793b1ce8946e343_.yxdb
Single
Profile
Warning
All
ByName
Union all word matches based on word length
Display word matches and their scores
Simple
FirstLetter_Match
=
Yes
If the first letter of the word is in our hand...
[FirstLetter_Match] = "Yes"
Sort the words ascending, just in case
Field_1 - Ascending
1-10
Top 10 scoring word matches
Finding matches based on word length
Simple
Field1_Length
=
2
Set aside all words that are 2 letters long
[Field1_Length] = 2
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
Simple
Field1_Length
=
3
Set aside all words that are 3 letters long
[Field1_Length] = 3
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
ThirdLetter_Match = IF Contains([Hand], [Third_Letter]) THEN "Yes" ELSE "No" END...
Simple
ThirdLetter_Match
=
Yes
[ThirdLetter_Match] = "Yes"
Simple
Field1_Length
=
4
Set aside all words that are 4 letters long
[Field1_Length] = 4
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
ThirdLetter_Match = IF Contains([Hand], [Third_Letter]) THEN "Yes" ELSE "No" END...
Simple
ThirdLetter_Match
=
Yes
[ThirdLetter_Match] = "Yes"
FourthLetter_Match = IF Contains([Hand], [Fourth_Letter]) THEN "Yes" ELSE "No" E...
Simple
FourthLetter_Match
=
Yes
[FourthLetter_Match] = "Yes"
Simple
Field1_Length
=
5
Set aside all words that are 5 letters long
[Field1_Length] = 5
FifthLetter_Match = IF Contains([Hand], [Fifth_Letter]) THEN "Yes" ELSE "No" END...
Simple
FifthLetter_Match
=
Yes
[FifthLetter_Match] = "Yes"
Simple
Field1_Length
=
6
Set aside all words that are 6 letters long
[Field1_Length] = 6
SixthLetter_Match = IF Contains([Hand], [Sixth_Letter]) THEN "Yes" ELSE "No" END...
Simple
SixthLetter_Match
=
Yes
[SixthLetter_Match] = "Yes"
Simple
Field1_Length
=
7
Set aside all words that are 7 letters long
[Field1_Length] = 7
SeventhLetter_Match = IF Contains([Hand], [Seventh_Letter]) THEN "Yes" ELSE "No"...
Simple
SeventhLetter_Match
=
Yes
[SeventhLetter_Match] = "Yes"
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
ThirdLetter_Match = IF Contains([Hand], [Third_Letter]) THEN "Yes" ELSE "No" END...
Simple
ThirdLetter_Match
=
Yes
[ThirdLetter_Match] = "Yes"
FourthLetter_Match = IF Contains([Hand], [Fourth_Letter]) THEN "Yes" ELSE "No" E...
Simple
FourthLetter_Match
=
Yes
[FourthLetter_Match] = "Yes"
FifthLetter_Match = IF Contains([Hand], [Fifth_Letter]) THEN "Yes" ELSE "No" END...
Simple
FifthLetter_Match
=
Yes
[FifthLetter_Match] = "Yes"
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
ThirdLetter_Match = IF Contains([Hand], [Third_Letter]) THEN "Yes" ELSE "No" END...
Simple
ThirdLetter_Match
=
Yes
[ThirdLetter_Match] = "Yes"
FourthLetter_Match = IF Contains([Hand], [Fourth_Letter]) THEN "Yes" ELSE "No" E...
Simple
FourthLetter_Match
=
Yes
[FourthLetter_Match] = "Yes"
SixthLetter_Match = IF Contains([Hand], [Sixth_Letter]) THEN "Yes" ELSE "No" END...
Simple
SixthLetter_Match
=
Yes
[SixthLetter_Match] = "Yes"
FifthLetter_Match = IF Contains([Hand], [Fifth_Letter]) THEN "Yes" ELSE "No" END...
Simple
FifthLetter_Match
=
Yes
[FifthLetter_Match] = "Yes"
SecondLetter_Match = IF Contains([Hand], [Second_Letter]) THEN "Yes" ELSE "No" E...
Simple
SecondLetter_Match
=
Yes
[SecondLetter_Match] = "Yes"
ThirdLetter_Match = IF Contains([Hand], [Third_Letter]) THEN "Yes" ELSE "No" END...
Simple
ThirdLetter_Match
=
Yes
[ThirdLetter_Match] = "Yes"
FourthLetter_Match = IF Contains([Hand], [Fourth_Letter]) THEN "Yes" ELSE "No" E...
Simple
FourthLetter_Match
=
Yes
[FourthLetter_Match] = "Yes"
Score the Words
First_Letter
Field_1
Field_2
FindWhole
Replace
Second_Letter
Field_1
Field_2
FindWhole
Replace
Third_Letter
Field_1
Field_2
FindWhole
Replace
Fourth_Letter
Field_1
Field_2
FindWhole
Replace
Fifth_Letter
Field_1
Field_2
FindWhole
Replace
Sixth_Letter
Field_1
Field_2
FindWhole
Replace
Seventh_Letter
Field_1
Field_2
FindWhole
Replace
Word_Score = [First_Letter] + [Second_Letter] + IIF(IsNull([Third_Letter]), 0, [...
Horizontal
scrabble_samjohnson