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 #231
Given the 15 unique variables, create a list of each of the combinations containing 3 variables (that is, 15C3). Remember, with combinations, order does not matter and the same variable cannot show up more than once in a given combination.
Since @Kenda is a vertical user, this week's challenge is also vertical!
Var1
Var2
Var3
Var4
Var5
Var6
Var7
Var8
Var9
Var10
Var11
Var12
Var13
Var14
Var15
1
2
3
1
2
4
1
2
5
1
2
6
1
2
7
1
2
8
1
2
9
1
2
10
1
2
11
1
2
12
1
2
13
1
2
14
1
2
15
1
3
4
1
3
5
1
3
6
1
3
7
1
3
8
1
3
9
1
3
10
1
3
11
1
3
12
1
3
13
1
3
14
1
3
15
1
4
5
1
4
6
1
4
7
1
4
8
1
4
9
1
4
10
1
4
11
1
4
12
1
4
13
1
4
14
1
4
15
1
5
6
1
5
7
1
5
8
1
5
9
1
5
10
1
5
11
1
5
12
1
5
13
1
5
14
1
5
15
1
6
7
1
6
8
1
6
9
1
6
10
1
6
11
1
6
12
1
6
13
1
6
14
1
6
15
1
7
8
1
7
9
1
7
10
1
7
11
1
7
12
1
7
13
1
7
14
1
7
15
1
8
9
1
8
10
1
8
11
1
8
12
1
8
13
1
8
14
1
8
15
1
9
10
1
9
11
1
9
12
1
9
13
1
9
14
1
9
15
1
10
11
1
10
12
1
10
13
1
10
14
1
10
15
1
11
12
1
11
13
1
11
14
1
11
15
1
12
13
1
12
14
1
12
15
1
13
14
1
13
15
1
14
15
2
3
4
2
3
5
2
3
6
2
3
7
2
3
8
2
3
9
2
3
10
2
3
11
2
3
12
2
3
13
2
3
14
2
3
15
2
4
5
2
4
6
2
4
7
2
4
8
2
4
9
2
4
10
2
4
11
2
4
12
2
4
13
2
4
14
2
4
15
2
5
6
2
5
7
2
5
8
2
5
9
2
5
10
2
5
11
2
5
12
2
5
13
2
5
14
2
5
15
2
6
7
2
6
8
2
6
9
2
6
10
2
6
11
2
6
12
2
6
13
2
6
14
2
6
15
2
7
8
2
7
9
2
7
10
2
7
11
2
7
12
2
7
13
2
7
14
2
7
15
2
8
9
2
8
10
2
8
11
2
8
12
2
8
13
2
8
14
2
8
15
2
9
10
2
9
11
2
9
12
2
9
13
2
9
14
2
9
15
2
10
11
2
10
12
2
10
13
2
10
14
2
10
15
2
11
12
2
11
13
2
11
14
2
11
15
2
12
13
2
12
14
2
12
15
2
13
14
2
13
15
2
14
15
3
4
5
3
4
6
3
4
7
3
4
8
3
4
9
3
4
10
3
4
11
3
4
12
3
4
13
3
4
14
3
4
15
3
5
6
3
5
7
3
5
8
3
5
9
3
5
10
3
5
11
3
5
12
3
5
13
3
5
14
3
5
15
3
6
7
3
6
8
3
6
9
3
6
10
3
6
11
3
6
12
3
6
13
3
6
14
3
6
15
3
7
8
3
7
9
3
7
10
3
7
11
3
7
12
3
7
13
3
7
14
3
7
15
3
8
9
3
8
10
3
8
11
3
8
12
3
8
13
3
8
14
3
8
15
3
9
10
3
9
11
3
9
12
3
9
13
3
9
14
3
9
15
3
10
11
3
10
12
3
10
13
3
10
14
3
10
15
3
11
12
3
11
13
3
11
14
3
11
15
3
12
13
3
12
14
3
12
15
3
13
14
3
13
15
3
14
15
4
5
6
4
5
7
4
5
8
4
5
9
4
5
10
4
5
11
4
5
12
4
5
13
4
5
14
4
5
15
4
6
7
4
6
8
4
6
9
4
6
10
4
6
11
4
6
12
4
6
13
4
6
14
4
6
15
4
7
8
4
7
9
4
7
10
4
7
11
4
7
12
4
7
13
4
7
14
4
7
15
4
8
9
4
8
10
4
8
11
4
8
12
4
8
13
4
8
14
4
8
15
4
9
10
4
9
11
4
9
12
4
9
13
4
9
14
4
9
15
4
10
11
4
10
12
4
10
13
4
10
14
4
10
15
4
11
12
4
11
13
4
11
14
4
11
15
4
12
13
4
12
14
4
12
15
4
13
14
4
13
15
4
14
15
5
6
7
5
6
8
5
6
9
5
6
10
5
6
11
5
6
12
5
6
13
5
6
14
5
6
15
5
7
8
5
7
9
5
7
10
5
7
11
5
7
12
5
7
13
5
7
14
5
7
15
5
8
9
5
8
10
5
8
11
5
8
12
5
8
13
5
8
14
5
8
15
5
9
10
5
9
11
5
9
12
5
9
13
5
9
14
5
9
15
5
10
11
5
10
12
5
10
13
5
10
14
5
10
15
5
11
12
5
11
13
5
11
14
5
11
15
5
12
13
5
12
14
5
12
15
5
13
14
5
13
15
5
14
15
6
7
8
6
7
9
6
7
10
6
7
11
6
7
12
6
7
13
6
7
14
6
7
15
6
8
9
6
8
10
6
8
11
6
8
12
6
8
13
6
8
14
6
8
15
6
9
10
6
9
11
6
9
12
6
9
13
6
9
14
6
9
15
6
10
11
6
10
12
6
10
13
6
10
14
6
10
15
6
11
12
6
11
13
6
11
14
6
11
15
6
12
13
6
12
14
6
12
15
6
13
14
6
13
15
6
14
15
7
8
9
7
8
10
7
8
11
7
8
12
7
8
13
7
8
14
7
8
15
7
9
10
7
9
11
7
9
12
7
9
13
7
9
14
7
9
15
7
10
11
7
10
12
7
10
13
7
10
14
7
10
15
7
11
12
7
11
13
7
11
14
7
11
15
7
12
13
7
12
14
7
12
15
7
13
14
7
13
15
7
14
15
8
9
10
8
9
11
8
9
12
8
9
13
8
9
14
8
9
15
8
10
11
8
10
12
8
10
13
8
10
14
8
10
15
8
11
12
8
11
13
8
11
14
8
11
15
8
12
13
8
12
14
8
12
15
8
13
14
8
13
15
8
14
15
9
10
11
9
10
12
9
10
13
9
10
14
9
10
15
9
11
12
9
11
13
9
11
14
9
11
15
9
12
13
9
12
14
9
12
15
9
13
14
9
13
15
9
14
15
10
11
12
10
11
13
10
11
14
10
11
15
10
12
13
10
12
14
10
12
15
10
13
14
10
13
15
10
14
15
11
12
13
11
12
14
11
12
15
11
13
14
11
13
15
11
14
15
12
13
14
12
13
15
12
14
15
13
14
15
All
ToNumber(REPLACE([_CurrentField_],"Var",""))
Remove Var
ToNumber(REPLACE([_CurrentField_],"Var",""))
Error
Create third row of numbers
Create third row of numbers
RecordID
1
Int32
6
0
Create ID field for Transpose
Create ID field for Transpose
Warn
Transpose to have all numbers in one column
Transpose to have all numbers in one column
Sort so that smallest number is always at the top
RecordID - Ascending
Value - Ascending
|
Combine all three values together
Combine all three values together
Convert number to string type
Convert number to string type
Remove any duplicate combinations
Remove any duplicate combinations
Concat_Value
Last
Concat_Value
Split out three numbers into columns again
Split out three numbers into columns again
[Concat_Value1] != [Concat_Value2]
AND
[Concat_Value2] != [Concat_Value3]
AND
[Concat_Value3] != [Concat_Value1]
Custom
Remove rows where there are dupilcate numbers
[Concat_Value1] != [Concat_Value2]
AND
[Concat_Value2] != [Concat_Value3]
AND
[C...
Remove unnecessary fields
Remove unnecessary fields
Sort to match solution
Name1 - Ascending
Name2 - Ascending
Name3 - Ascending
C:\Users\JOSHUA~1.GOS\AppData\Local\Temp\Engine_14412_dda3df4d9d39469f9fa3bf8b2c317318_\Engine_23768_b6dac86847e240ae88ac6e5be875f7f7_.yxdb
Single
Profile
Final output
Final output
Joshua Gostick
03/09/2020
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Error
Create second row of numbers
Create second row of numbers
Vertical
challenge_231_JG