Incremental load when reading files via FTP?

Anonymous — Tue, 26 Apr 2016 15:22:13 GMT

I am trying to read files via FTP from a particular location. Each month a new file will be dropped in this location. I would like to read this to perform incremental load and append to existing qvd each month.

Files are in csv format. FTP has username/Password information.

How do I check if the files exist in the a certain location ?

I was using

FOR Each HFile in filelist ('ftp://Username:Password@SERVERNAME/*.csv')

but it fails to read the file.

Any help is appreciated.

Thanks

Re: Incremental load when reading files via FTP?

marcus_sommer — Wed, 27 Apr 2016 07:32:08 GMT

The ftp-protocoll don't support wildcards or any file-functions like filelist. But there are workarounds for it, see for example:

Re: For Each File in Filelist - FTP load is not working?

Re: FTP data import into script

- Marcus

topic Incremental load when reading files via FTP? in QlikView

Incremental load when reading files via FTP?

Re: Incremental load when reading files via FTP?