Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
twanqlik
Creator
Creator
‎2016-12-14 12:22 PM

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


266 Views
0 Likes
0 Replies