Rejoin and Output
Complete?
Warning
All
ByName
Challenge Number - Ascending
Output55
O
Challenges
Thread Call
String
65001
GET
Compose
2
600
Contains([DownloadData],[Username])
Custom
Contains
DownloadData
True
fixed
2018-08-20 17:12:31
0
mceleavey
2018-08-20 17:12:31
2018-08-20 17:12:31
Contains([DownloadData],[Username])
Thread
Call
Thread Call = 'http://community.alteryx.com/restapi/vc/threads/id/'+[Thread1]+'?...
DownloadData
ParseSimple
Warn
url_Matched
Tokenize:
td-p/.*?"
Contains([DownloadData],"Weekly-Challenge")
Simple
Contains
DownloadData
True
fixed
2018-08-20 17:05:33
0
Weekly-Challenge
2018-08-20 17:05:33
2018-08-20 17:05:33
Filter
URLs
Contains([DownloadData],"Weekly-Challenge")
1
ParseSimple
Thread
Warn
url_Matched
Tokenize:
\d+
DownloadData
ParseSimple
Warn
Username_Matched
Tokenize:
Challenge [#]\d+:
1
ParseSimple
Warn
Username_Matched
Tokenize:
\d+
Index
https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275
mceleavey
url
String
65001
GET
Compose
2
600
DownloadData
ParseSimple
url_Matched
Tokenize:
<td.*?</td>
DownloadData
Replace
Warn
url_Matched
]]>
DownloadData
Replace
Warn
url_Matched
]]>
Skip
36
Skip 1st 36
Challenge
No.
Challenge Number
New Field
Int32
4
Empty
if [Challenge Number]='0' then [Row-1:Challenge Number] else [Challenge Number] endif
Final
Challenge
No.
if [Challenge Number]='0' then [Row-1:Challenge Number] else ...
DownloadData
Replace
Warn
url_Matched
DownloadData
Ignore
DownloadData
,
SmartTile
Challenge Number
Smart Tile:
Challenge Number
Headers
Headers = if [Tile_SequenceNum]=1 then 'Challenge Number' elseif
[Tile_SequenceN...
Formula
titlecase(replace(replace([_CurrentField_],'-',' '),'_',' '))
Challenge Name
Replace
Warn
Challenge Name_Matched
"Challenge Number","Challenge Name","Difficulty Level","Main Subject"
True
True
True
False
False
False
False
False
False
upper
Horizontal
Question
Text Box (28)
Weekly Challenge Index
See all weekly challenges with the difficulty level and main subject, and see if you've completed it or not.
Weekly Challenge Index
2.0
Connectors
Connector, Download, Challenge, Parse
mceleavey
NoCondition
(Always Run)
Dynamic
{{INPUT}}
12/Data/r[1]/c[2]
Update Cell
Expression
row 1
column 2
Tab
Questions
Tab (25)
TextBox
Username:
Text Box (28)
MacroOutput
Macro Output (55)
Macro Output (55)
Macro
iVBORw0KGgoAAAANSUhEUgAAAKsAAACrCAYAAAAZ6GwZAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwgAADsIBFShKgAAAEfBJREFUeF7tnf1TFEmax+8/uri4i/OHi9iLi7nYiIvd2924i3Fv45zRndURnTnndsaXA3zBN0R5f4du6IamX6q7ebGBBuX9ReXFFwRfEAVEUBwFARlABOE5qk0V9YGu6uqqyqzOT8Tnh5EiK7PzO01VZWXm3wCHwwgRGda5+dfQPzgOCfkX4Q+7c8Dtdn+m1eaCkxmV8Hj8GcwvvCK/ydGTiArr6OgoWIRGSMoqQQO6mSZnAww+miQlcfQgIsI6v/Aaaupa0RDKMa/QCf76K/DmzQopmaMlhg+r+G1qKipFwxequRYP3B54TM7A0QpDh7X33mP44WgBGjilWm0C9NwdJ2fiaIFhwzo2PgHxqTY0aOH03sPn5Ix00NQ5CLWt/eBr6IHz9TfAV98DNWv/XduGK/5M1rFrxwSOXfsd8TzYcaLiseffH3szyLF33x9b2dj70c86bj4iLTNoWFdXV8HlLkfDFW5zCsvg9dIbcmb9iYotRuvJotv3F8LzF3OkZQYNa3xeE9p4tTS7msmZ9Wd3jAWtI2smZjng0ZNp0qq3GC6sL2bm0caraabJRc6uP7uj2Q+rsObg6AvSog8YLqy9dx6iH4Damt2XSQ30JSqmCK0fK1ptbniwwfNsw4X14NkK9ENQW6e7gtRAX6Ji1b+pVMvjSUXQue6G6lMMF1bsQ9BCj5eOGy1Ww+oS1v781/SSVuAYKqyzc4voB6GFLncpvFpcJjXRDxbDmmN2gPdCH2nBxvCwhkmXwMMaql7/VVL7zeGXAWGSlssArG606nIJcNbcRGoeHMOF9afT+Aejtj6fj9RAX7C60erZPL+sl4IMF9bOa3fRD0ZtC0ql/SlTG6xuNPqXGDepsXQMF9bJae0HBdLz6BkUwOpHm8WCn9RWHoYLq0hcZj36IallXWMbObP+YPWjyYPxAqmpfAwZVvFFFsGjzeCA+MIMTWB1pMVCWzk8m/yF1FQ+hgyryMDDCbDYPOiHFi5PJhfD1b4RckY6wOpJg1HRJnj88wypZWgYNqwi12+PQdw59cbKO3qGyZnoIfqMHa0rDZZf6CS1DA1Dh1Vk+NEz2HUo/LMFRsfonCVA+6BAe0cPqal8DB/WdxxL96MfnhwFwQ1fHbTDygq9EwZZGMFKsbaS2sojYsL6jlJfHdid8q5lzVYXVFbXwr2hp6QUemFluLVAkP8EJeLC+g7BfwNqLjRBhrks8I25/oMsLHIF/v1CfSvUtNyC2Tl2Frlg5X3W/EIHnMxpjOwRLCVMz76Cxdf6v4yiBJZmCoivBZ7KriE1Dw4Pq8GIYnAOlsnVQmq/OTysBoPFVwRFqy4GnxbEw2owsCCw4uXLmweWh9VgYCFgycqqjV9y4WE1GFgAWHNXrABLyIvsERnW8vrbYHY1QYm7BpJyPHAiuSRgUo4bbG4/eCtboazuFqysrJLfYAes81lTfJT445nzpEUfiJiw9vSPBx7sp2RLHztPzi6BqMMC3Bumaz2rzcDawarx2R9fEhg+rOKz0x+OO8Fmd6EfiBTtDgHOZAgw/myKlEovWP3X+w//kQbfnSgPuDfOC3uOCQH3nih7/++Ye+M8b4+TdKz7/bHfBTv22ObHmj3dpGUGD6uvoQ/2HTGjnRaKCek28NX3wSrFVwdYvde7ZWsWOZI9DBvWJIvyla4xLcUuOJnTQO1IF1bn9W7ZmkmOZA9DhjXJ0hYIFdZZ4fLIuRJo6RoiZ6QHrK7r3fJlKjmSPQwX1r57Y2gnqWFSpg0ybaG97qYWwUaweFgpYXp2AUxWAe0ktSwscsL3J+lYM0AkeFgzyJHsYaiwVjf3ox2ktuLbQ7/algdLy/q/lB00rPwGiw6wztHSf9mWAU+evSS10QceVgboH36Odo7W7jxogss3HpJaaU9swuaDHjysFNDedQftHD08nmiF4ooPD7O1BKvPenlYKaCvrw/tHL3MNjngcNpFUjvtwOqy3n/kYdUf2sIqWmIX4Pd7bWs3XtothYnVY71p+U5yJHvwsGrgli/TYWpmgdRUPYZHJ9Dzfyqr8LBq5Jc/5MKdB+Hf73VpaRmqGq6j59xIVuFh1dimzn5SY2WIU5g7eobQcwSTVXhYNTY51w6JhcqGaB+MPAdvRQ1avhRZxTBhbWnvQjuGRq3FLtgR7Q3pxqvc3xbY3QQrV6qsYpiwNjRfQTuGVsWpG/+2ywxTL6XdeBV4uyDfovy9hy/2mEmJ7GGYsNbWX0I7h3b/fWd64M/6RvQPiSNz4Vtnlg8KUICvpgXtHBb8/nABNHd+/G7sxPR8YEIjdrwSeVgpwHO+Du0cVjyTbgOTtzswo9bpu4weEw55WCnAWXoR7RwtFIlNrwG7U9k1pdnqhH3H1F2rShygYBXDhNXh1e+bVUTcdMNe3QtZZid6DC3ymQIUUOS6gHaOFq6n69YYHE0uQY+jwS1fppGasodhwmq2K1+GPVQ/5enELOyIsaLH6i2/ZqWAnKJKtHO0EGPk2Sy4POXo8WpoKRbgQGIN7I7efOVrHlYKyCg4j3aOFm7Ey7lF8PjUv/HbGSO8n07Dp7UwQHKedt9in7oZb1ZWobH9KuRawr+OQexZBzR98nyWh5UBErK8aOdooRTqLt2HM2nhufE6dq4Y6tr6SMkfExXkWpmHlQJOpih7uUOJUrk/MgFRccVoGVI9lX0B5uZfkxI/J9gGGDysFHAsUb/HRXIYejK19jvyxvrFpTf/9vfpMDMbfIujYBtg8LWuKCA2gY2wviPHKQ6pBg9tdLwNqpqlv7AdfEUWPiigO1jHaGWodPeNwY/x+OVLclYJVNTK35iXh5UBsI7RSqVc670PZnstHDpdDHFJDrjYeAkmpubIT+UR/GkAvwzQHaxjtJIm+KMrBsA6RitpgoeVAbCO0Uqa4GFlAKxjtJImgu2KzcOqM3Pzi2jHaCVN8EEByhkefYZ2jFbSxG4+KEA394aeoh2jlTQRFbv5cC5/zqozd4f4N+s7+KAA5dzsH0c7Ritpgg8KUE5X7yjaMVpJE/zRFeW0XXuIdoxW0gQPK+U0XHmAdoxW0gQPK+X4W/TZ/+qdNBH0aQAPq75U1N1GO0YraYIPClCOp+YG2jFaSRPBwvpPX+eSI9nDEGFt6RxAO0YrX1G0nft/xQSfMcEqhgjrzC+v0E7RyhyLB2qbuqCi/g703B2HuYWNJ/SpzdbYzXcYFGUVQ4R1YETaljpaeiLFASWeWujsugaW0i7o7h2B+YVFUmP14GGlHEdVD9optHkuwwYmqxfKzvvhmxgvmD3dgZWtw8kf+WUA3fz1TBXaKaxYXCKAU/BApskFf/rRARfa75OWyefbIM9ZRVnFEGH1VbO96vVGJltaYfnNCmmlNHbE8LBSTX5RGdopRvCb/3PAwuISaWlwtsbyywCqoX21aaXGpnhJS4OzlX+z0sul6/q+xKKVe+LKSIs3h4Wwtl0bhoT8RvJf0mE+rCey9FueXUtdLjeMPZ0hrd6YrRQ+DRB3oDG5u6CiokJRPZgP63lf9UcfgJH95/8O/uJ0sOesf7cjnxypPu6aXvjd7nwoceC72MiF6bCK/8d6vPotIqyH1c13SetxgoVVzQ0wFl4tQXffQ/j1n/PQc3+qXJgO6/LyChSVhL5VpKOsAZ78/BJWV9+Wd3Xtg860t0NTcwt4yv2QZsJ/T093xxTA0NiLtxVGCBbWv/9jNjkyPLx+vQx9A08h2VyLnm8z5cJ0WMVdpa220Jc/z3F2kJI25uqD52BvvAflTT3Q0dkNZpsPYuI3X0hCba1CLand52g13Do0OgH++g7432Oh70ojF6bDWlZ3C/0QpCrO3QqV51PzUH/9EbT3DEJNYxfEZ1XAn/bloudRw5LaXlKTj1E7rFVNt8DurganS9luimm5dlKidJgO687Doe8jcDChGJaWwv9qn7gl+9DoJFy/9RBsZZdhZ7QDihR8+29kphl/9qpWWA+nXYRCW/j2bYi4sDoU7JWamO0hpaiPuFXm0tr19avFZRh5/AJO5DSgdZLrD6eryBk+EM7nrOIN0xd/NqNlKDU1z0HOIh1mw/piZgH9EKRaXiX/oXQ4uTc0DknZypaWN1lcMP/Ju7PhCOvk9DwcTgz9xlWqcmE2rMNj4kYS+IcgxfaOm6Qk/fjqIF43Oe44YA08FXmHkrA+m/wFjmdos61osV0gZ5UOs2HtvTeGfghSrW0bICXpS5YZr59Ut0cXQHPHhw0yQrlmFZ+q2Hw3oKgEP14NI+qa1eJuRj8EqYrfzDRQ4L2K1k+O8anFgW9FkW0yh1vN3m5IzVV2Zx+KERXWnUE21N3MvUcspBQ6KLQrGzLONDnA4mkNlBVskQtREXtlDxTZS9Gfa2HEhHVW4QTBc3mf30XrSc/dJ+AS8LpKVfz9S9dHJIU13SyAoPB8So2YsA48VDZBsPlSDymJHrzV7Whd5ZiSXwHfRivbblMrIyasTZ2D6AcgVXHTX9oQHxel5Id/8IBWIyasN/uUrW11+/7PpCS66Lg5jNbXiEbMoIDZUY9+AFL8OqYQJqbe3jnThjg5MPosXm8jKhcmw7rrSOgjP3+IyiOl0MnLtZtHmx2vu9GUC3Nhff5iDm24VBNNNaQkejmaYcyp5etNiYTLgNZuZdd1PbeHSUl0k5Kv/ti8nkbEDVa+0Ik2XqrPJoNPuqOB5u4hyDLj27sbwYgI64X6VrTxUh0nw5IskFkU+o0k7UZEWHOtH0/nlesbmcvx6MnE1BwcOBn6tBGajYiwKum83/5UQkphh/JGfZegV0vDh1XpOqy5EiYI0sTNm71oO4yg4cMqvimENVyK4hSY0fFpUhLdiCtn7z0WvvlONGr4sKYUhT53yWwVAnOhaGdg+Dls/0mdeU+0KRemwuqrvog2WopOd9n7xSxopbpJ2dRy1pQLU2E1F4e+Dmu1309KoROX7wpabyMrF6bCeiot9HcCvjrpI6XQh1DRhNbZ6MqFmbBeujGCNliqVU2bL2imF9sP4fWNBOXCTFhPZIU+mlNc4iKlaMfcwiJMTs3B2NNp6B+ZhKmpqYDXegehvr0P3P5u2HM0cl62xpQLE2EV74v2nQp9nDwtX/4HIwVxhZX7IxPQ0j0Eg0PD4ChvDbyPejYj+DworkHDKr6UrGQdVk/5xqvuyeHGnTGwll8D/8V2SMkrg8x8475oooVyYSKsi6+Xodge+itzJ0z1pCR5XL/9GA6n+kEorQKzNbL/ZKuhXJgI6/zCEuQXhv4tlu/uIiUFJ9vZATv2W8FiE0BAyuKGT7kwEdaKemUPy6+ufUNirKyuwvTLBdifUAUZecGX3eGGV7kwEdbdR0NfOWRPtJmU8oHBR5NQILTCXw7ko7/D1Ua5UB/WNyuraEOlejbr7Tqso+NTkOvqgF2HLOhxXO2VC/VhFRd/wBoq1VOpTvjP/7HCoVOF6M+5+ikX6sMq/snGGsplX7lQH9ab/eNoQ7nsKxfqw1pSfhltKJd95UJ9WKNi2VgVjytfuVAf1i+2paAN5bKtxSb/5SLqw/qvX2eijeWybVqu/JnG1If1aGol2lgu2xpywuCBhNCnsnDp1TBhFbdmr2q6gzaSawwNEVbxZeYdB/TddZqrvkyHdXZuEUqr2sBm135PJq72MhvWioY7cC6Tv3UfSTIZ1iyrNnuFcumSqbBWrt1AnU7lE+siVXGTObloHtapmXnY9hMfQo1002kfFGi8MgA7D5rQynMjS6ovA2JSauBIgjFXceaGplxUD+vQo+dwNNEBWfl8Qh73g9TtMOjwXYWENH59yv1cqi4DSkv5mD53Y6kI6y/zi3Aqja9ewt1c3cPa0jkAv96ejlaOy12vbmEV35LKKmmBAqsTrRiXiykXxWF9tbgE3x/3wv7jkbFpAzd8ykVRWKdn5uA335oCoxFYZbjczZRLyGF9PP4C9h0pQCvB5QZTs2vWOwOP4UwafwmFG7qahPXG7TH4zTf8jp+rTNXD6vb3wDf7c9GTc7lyVDWsXn8nxJ3jy0Vyw6NqYY3Pq0NPyOWGqiph3X/2PHoyLleJYQ/rd8fLIC6Rv4PKDb9hmykg7jv11/gKyCvgM0656hi2sJ7OuQiCgJ+Eyw2HBUVOkjbpfBZWq7cdLZzLDbdyCXqDxeHQAcD/A2qetjSJLnyYAAAAAElFTkSuQmCC