C:\ProgramData\Alteryx\Engine\Engine_7560_6f83ba45d51947739c071856ddd1bdc9_\Extract\2018_CPI_FullDataSet.xlsx|||`CPI2018$`
False
1
ReadList
FileName
Path
Contains([Field_1],"Fulldata")
Simple
Contains
Field_1
True
fixed
2019-05-15 22:04:51
0
Fulldata
2019-05-15 22:04:51
2019-05-15 22:04:51
Contains([Field_1],"Fulldata")
Error
C:\ProgramData\Alteryx\Engine\Engine_7560_6f83ba45d51947739c071856ddd1bdc9_\Engine_9644_c39189bf21d9443e9872d32ce6669f07_.yxdb
Single
Profile
!IsNull([Corruption Perceptions Index 2018: Global Scores ])
Simple
IsNotNull
True
fixed
2019-05-15 22:42:04
0
2019-05-15 22:42:04
2019-05-15 22:42:04
!IsNull([Corruption Perceptions Index 2018: Global Scores ])
Find and download ZIP document
URL
String
65001
GET
Compose
2
600
DownloadData
RecordID
1
Int32
6
0
[RecordID] = 1133
Simple
=
RecordID
True
fixed
2019-05-11 21:56:11
0
1133
2019-05-11 21:56:11
2019-05-11 21:56:11
[RecordID] = 1133
"DownloadData"
True
True
True
False
False
False
False
False
False
upper
DownloadData
Last
Data
URL2
SpecificFile
FilenameWithDir
GET
Compose
2
600
https://www.transparency.org/cpi2018
CPI2018
file.zip
extract\
https://www.transparency.org
URL2 = [Domain]+[URL2]
FilenameWithDir = [Engine.TempFilePath]+[NewFileName]
Fil...
Unzip document
cmd2 = '"C:\Program Files\7-Zip\7z.exe" x ..\"' + [NewFileName] + '" -aou -o"' +...
mkdir Extract
pushd Extract
Set Up Cmds
popd
Warning
All
ByName
#1
#2
#3
#4
#5
%temp%\zip.bat
CRLF
Never
False
28591
True
%temp%\ziplist.txt
65001
\0
False
254
False
False
DoubleQuotes
1
%temp%\zip.bat
Run zip.bat
ziplist.txt"
]]>
popd
Horizontal
Download_Community