Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

twanqlik
Not applicable

Daily load in a .QVD file

I can use some help on the below situation

Everyday a zipfile with 5 .csv files is placed on a FTP server.

The zipfile name has each day a new datestamp:

Name – date1.zip

Name – date2.zip

etc.

The .csv files have every day the exact same name + format.


I want to automate this process in such a way that:

  • The new zip file is downloaded every day (old zipfiles are not removed from the FTP server)
  • Extract the zip file
  • Import/add the data from the .csv files in a .QVD (what is better for the performance, adding the data to the existing .QVD or create a new .QVD for each .csv file)
  • Delete the .csv files and place the zipfile in an archive folder


I'm new to Qlikview and i don't think that i'm asking something new, but i can't find a smiliar topic where i can learn how to script this