https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275
URL to Weekly Challenge Index & Welcome
URL to Weekly Challenge Index & Welcome
DownloadData
split by new line
split by new line
RecordID
1
Int32
6
0
DownloadData
Split to rows to identify values
Split to rows to identify values
!StartsWith([DownloadData], "<")
Custom
filter for rows with values
!StartsWith([DownloadData], "<")
DownloadData
Last
DownloadData
Break out values from remaining HTML tags
Break out values from remaining HTML tags
,
crosstab on column number
crpsstab on column number
RecordID
PivotMe
Int32
4
Empty
[Row-1:PivotMe]+1
Identify column position
[Row-1:PivotMe]+1
FirstRow
Warn
Field1
String
65001
GET
Compose
2
600
Change RecordID to string
Change RecordID to string
Remove HTML tags
DownloadData = Replace([DownloadData], '" target="_blank"', '')
DownloadData = R...
Simple
Contains
DownloadData
True
fixed
2023-03-21 21:18:45
0
http
2023-03-21 21:18:45
2023-03-21 21:18:45
Identify HTMLs
Contains([DownloadData],"http")
RecordID
RecordID
URL
FindWhole
Append
Change RecordID to string
Change RecordID to string
Contains([DownloadData],"table>")
Custom
Identify start and end of table
Contains([DownloadData],"table>")
Max and Min Records
Max and Min Records
Error
Append
Append
Identify records to filter for
FilterMe = IF [RecordID] >=[Min_RecordID] && [RecordID] <=[Max_RecordID]
THEN 1
...
Simple
IsTrue
FilterMe
True
fixed
2023-03-21 21:30:59
0
2023-03-21 21:30:59
2023-03-21 21:30:59
[FilterMe] = 1
Contains([DownloadData],"TR")
Custom
Filter for table rows
Contains([DownloadData],"TR")
RecordID
FilterMe
Bool
1
Empty
IF [1] = "#"
THEN 1
ELSEIF [Row-1:FilterMe] = 1
THEN 1
ELSE 0
ENDIF
Rows to remove = False
IF [1] = "#"
THEN 1
ELSEIF [Row-1:FilterMe] = 1
THEN 1
ELSE 0...
Simple
IsTrue
FilterMe
True
fixed
2023-03-21 21:39:56
0
2023-03-21 21:39:56
2023-03-21 21:39:56
Filter for rows to keep
[FilterMe] = 1
Parse Alteryx Weekly Challenge Index
Created By: Stefano Mallozzi
Deselect RecordID
Deselect RecordID
List Box (55)
Contains([Main Subject],"Apps")
Custom
Contains([Main Subject],"Apps")
Update Value
Contains([Level of Difficulty],"Basic")
Custom
Contains([Level of Difficulty],"Basic")
Contains([Certification Level],"Core")
Custom
Contains([Certification Level],"Core")
Update Value
Update Value
Check Box (85)
Update Value
Check Box (87)
Update Value
Check Box (87)
Update Value
C:\Users\E087201\AppData\Local\Temp\Engine_19220_78212eb8899940ad8e428c27e3e5f56b_\Engine_28592_2491ee4e43214be58c48bae8664a3787_.yxdb
Single
Profile
Results
List Box (92)
List Box (93)
C:\Users\E087201\AppData\Local\Temp\Engine_19220_78212eb8899940ad8e428c27e3e5f56b_\Engine_28592_8d0a8b2df4584e818bac145c5d5883f0_.yxdb
Single
Profile
Text Box (97)
Update Value
Check Box (99)
List Box Options
Main Subject
,
FirstRow
Warn
Level of Difficulty
,
FirstRow
Warn
Certification Level
,
FirstRow
Warn
Simple
IsNotEmpty
Certification Level
True
fixed
2023-03-21 22:52:52
0
2023-03-21 22:52:52
2023-03-21 22:52:52
!IsEmpty([Certification Level])
Horizontal
Question
List Box (55)
Question
Check Box (85)
Question
Check Box (87)
Question
Check Box (89)
Question
List Box (92)
Question
List Box (93)
Question
Text Box (97)
Question
Check Box (99)
Parse Alteryx Weekly Challenge Index
NoCondition
(Always Run)
UpdateValue
Simple
59/Expression
UpdateValue
Simple
75/Expression
UpdateValue
Simple
78/Expression
Dynamic
{{INPUT}}
58/DetourRight/@value
Update Detour Direction from Question
Expression
Dynamic
{{INPUT}}
74/DetourRight/@value
Update Detour Direction from Question
Expression
Dynamic
{{INPUT}}
77/DetourRight/@value
Update Detour Direction from Question
Expression
Dynamic
{{INPUT}}
1/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
Tab
Questions
Tab (54)
BooleanGroup
Check the box to filter Main Subject
Check Box (85)
ListBox
Select Main Subjects
List Box (55)
Contains([Main Subject],"
") || Contains([Main Subject],"
")
Field
Output
Bool,Byte,Int16,Int32,Int64,FixedDecimal,Float,Double,String,WString,V_String,V_WString,Date,Time,DateTime,Blob,SpatialObj
BooleanGroup
Check box to filter Level of Difficulty
Check Box (87)
ListBox
Select Levels of Difficulty
List Box (92)
Contains([Level of Difficulty],"
") || Contains([Level of Difficulty],"
")
Field
Output
Bool,Byte,Int16,Int32,Int64,FixedDecimal,Float,Double,String,WString,V_String,V_WString,Date,Time,DateTime,Blob,SpatialObj
BooleanGroup
Check box to filter Certification Level
Check Box (89)
ListBox
Select Certification Levels
List Box (93)
Contains([Certification Level],"
") || Contains([Certification Level],"
")
Field
Output
Bool,Byte,Int16,Int32,Int64,FixedDecimal,Float,Double,String,WString,V_String,V_WString,Date,Time,DateTime,Blob,SpatialObj
BooleanGroup
Optional
Check Box (99)
TextBox
If needed to update the URL to the Weekly Challenges, paste below:
Text Box (97)
https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275
Wizard