Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Not applicable

Delete file from FTP after load

Good day.
We have an issue with load from remote FTP:
our partners give us access to their ftp where they deploy daily XML files, with one condition: we should delete files after load.

It`s easy to load from, like:

campaign:

LOAD     *

FROM [ftp://loginSmiley Tongueassword@host/file.xml] (XmlSimple, Table is [campaigns/campaign]);

But I confused by second part of task.

How can we remove files after loading? I will be very grateful for any ideas.

1 Reply
Not applicable

Re: Delete file from FTP after load

I used standart windows shell ftp client through the exec command in QV script.

Community Browser