Hey everybody,
i do have the following ftp connection problem which arised through an Update to Qlik Sense 3.2.
For more than a year this syntax worked in Qlik Sense 3.0 like this:
Table1:
LOAD
*,
FILEBASENAME() as Filebasename
FROM
[ftp://Username:password@IP/$(vFile)]
(txt, utf8, embedded labels, delimiter is '|', msq);
$(vFile) is a variable which contains the filename.
Now i updated the server to Version 3.2 and when refreshing data Qlik Says "This statement only works with lib:// paths in this script mode." So i created a Lib which contains the ftp expression (ftp://Username:password@IP/) and the syntax changed to the following:
Table1:
LOAD
*,
FILEBASENAME() as Filebasename
FROM
[lib://FTP/$(vFile)]
(txt, utf8, embedded labels, delimiter is '|', msq);
$(vFile) is still the filename.
Now, Qlik completely ignores any syntax after lib://FTP. I can type in any expression, even ABCDE of whatever. It always gives me list with all files on the ftp server. But i want a specific file which is on the ftp server. Around this expression is a loop, because the file name changes every time and that's why we are using a variable.
Does anybody have an idea for a solution?
Thank you folks
