HELP PLEASE!
', '')
Award = Replace([Award], '', '')
]]>
DownloadData
ParseSimple
URL_Matched
Tokenize:
<h3>.*?</h3>
https://www.sagawards.org/awards/nominees-and-recipients/24th-annual-screen-actors-guild-awards
URL
String
65001
GET
Compose
2
600
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class=.*?</span>
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="movie-title-gr...
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="nominee-name">...
RecordID
1
Int32
6
0
RecordID
0
Int32
6
0
Nominee = [DownloadData]+[Film Recipient_DownloadData]+[TV Recipient_DownloadDat...
Nominee = Replace([Nominee], '<span class="nominee-name">', '')
Nominee = Replac...
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="winner-prefix"...
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="movie-title ">...
Winner = Replace([Winner], '<span class="winner-prefix">Recipient</span>', 'Winn...
Film = Replace([Film], '<span class="movie-title ">', '')
Film = Replace([Film],...
RecordID
1
Int32
6
0
RecordID
-1
Int32
6
0
Error
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="movie-title-gr...
RecordID
0
Int32
6
0
Film = Replace([Film], '<span class="movie-title-group">', '')
Film = Replace([F...
!IsEmpty([Nominee])
Simple
IsNotEmpty
Nominee
True
fixed
2019-02-03 19:25:37
0
2019-02-03 19:25:37
2019-02-03 19:25:37
!IsEmpty([Nominee])
"Nominee","Film"
False
False
True
False
False
False
False
False
False
upper
RecordID
1
Int32
6
0
RecordID
New Field
Int32
4
Empty
IF [Row-1:New Field] = 5 THEN 1 ELSE [Row-1:New Field]+1 ENDIF
IF [Row-1:New Field] = 5 THEN 1 ELSE [Row-1:New Field]+1 ENDIF
RecordID
TAG
Int32
4
Empty
if [Row-1:New Field] =5 then [Row-1:TAG]+1 else [Row-1:TAG] endif
if [Row-1:New Field] =5 then [Row-1:TAG]+1 else [Row-1:TAG] e...
URL
Ceremony_Number
Int32
4
1
Ceremony_Number<=25
Ceremony_Number+1
Abbreviation = Replace([Abbreviation], '1', 'st')
Abbreviation = Replace([Abbrev...
RecordID
1
Int32
6
0
Ceremony = Replace([Ceremony], '11st', '11th')
Ceremony = Replace([Ceremony], '1...
RecordID - Ascending
RecordID - Ascending
URL
ParseSimple
Warn
URL_Matched
Tokenize:
ts/.*?-screen
1 = Replace([1], 'ts/', '')
1 = Replace([1], '-annual-screen', '')
1 = Replace([...
RecordID
1
Int32
6
0
DownloadData
ParseSimple
URL_Matched
Tokenize:
<d.*?v>
!IsEmpty([Award])
Simple
IsNotEmpty
Award
True
fixed
2019-02-09 16:56:40
0
2019-02-09 16:56:40
2019-02-09 16:56:40
!IsEmpty([Award])
"Award"
True
True
True
False
False
False
False
False
False
upper
Abbreviation = Replace([Abbreviation], '1', 'st')
Abbreviation = Replace([Abbrev...
Ceremony = Replace([Ceremony], '11st', '11th')
Ceremony = Replace([Ceremony], '1...
Award
New Field
Int32
4
Empty
if not(isempty([Award])) then [Award] else [Row-1:Award]
endif
if not(isempty([Award])) then [Award] else [Row-1:Award]
endif
RecordID
1
Int32
6
0
Ceremony
Replace
Warn
RecordID2_Matched
Replace:
^1st
Inaugural
UniqueValue
Unique Value
RecordID - Ascending
[Tile_SequenceNum] <= 5
Custom
=
True
fixed
2019-02-09 22:49:12
0
2019-02-09 22:49:12
2019-02-09 22:49:12
[Tile_SequenceNum] <= 5
RecordID
1
Int32
6
0
DownloadData
ParseSimple
URL_Matched
Tokenize:
<span class="movie-title no...
RecordID
1
Int32
6
0
Error
C:\Users\Seffana\AppData\Local\Temp\Engine_6168_19fc53fb9bf841c99703db03236e6c8e_\Engine_19284_e43ebe9672df48c5b25ae9c496cb8018_.yxdb
Single
Profile
"RecordID","Nominee"
False
False
True
False
False
False
False
False
False
upper
!IsNull([RecordID])
Simple
IsNotNull
RecordID
True
fixed
2019-02-09 23:22:01
0
2019-02-09 23:22:01
2019-02-09 23:22:01
!IsNull([RecordID])
Horizontal
SAG Awards