Hi experts,
up until recently I used the following script successfully to pull data from xlsx-files into my QV app (taken from the thread Re: For Each File in Filelist - FTP load is not working?). This worked fine with QV11, and also with the first edition of QV12, but for some reason it doesn't work with QlikView November 2017 SR5, Version 12.20.20600.0. I always get the error mesage "Unknown LOAD statment error" for the first LOAD statement (see below). Does anybody know what needs to be changed so it works again?
////////////Connectig only Directory listing through WebFiles Button,
///////////then split Directory listing into 4 Section Date = F1, Time = F2, Type of File/Directory = F3, Name of File or Directory = F4
LOADER:
LOAD F1,
F2,
F3,
F4
FROM
[ftp://username: pass%40word@kolkataivf.net]
(html, codepage is 1252, embedded labels, table is @1, filters(
ColSplit(1, IntArray(11, 24, 34))
)) Where right(F4,4)='xlsx';
let vRow = NoOfRows('LOADER'); ////// Checking No of Rows for xlsx files
For i = 0 to $(vRow)-1
let vFile = peek('F4',-1+$(i),'LOADER'); ////// Remember if All file structures are same then you can execute this script and Last Row started with ‘-1’
LOAD COMPANY,
CEO_NAME,
ADDRESS1,
CITY,
PIN,
EMAIL
FROM
[ftp://username: pass%40word@kolkataivf.net/$(vFile)] /////Now Concatenating File with Connection Bec’z for each file transfer FTP require new connection
(ooxml, embedded labels, table is Sheet1);
Next i
