Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Storing Multiple csv files with date stamp and store history onto qvd

Good Day,

I have created attached script to try and consolidate multiple data from csv files with date stamp. I want the data to be stored on a qvd and everyday when the file gets dumped, qlikview will only load the latest data.

I am getting below errors when executing the qvd generator

  • Script line error: next File
  • Script line error: next Ext
  • Script line error: end sub

Can anyone assist?

4 Replies
eduardo_dimperio
Specialist II
Specialist II

Can you use

Load

*

From *.csv

This will concatenate all csv files

Not applicable
Author

I am aware of that solution but it is not the most viable because each time the generator is run, it will do the full reload. The script I am working on is supposed to initially do full reload and then afterwards, it will check the last file that was loaded and only load for the newly dumped file.

eduardo_dimperio
Specialist II
Specialist II

Ahhh... well i have a similar case where and what i do is name all csv with a incremental number, so i run once all csv with the code that i wrote to you and after i create another qvd just to safe the name of all csv already loaded.

Every new load  i just pick from that list the last csv number, increment +1 and load.

eduardo_dimperio
Specialist II
Specialist II

Another solution is using  filetime() and get the max() on your csv file.

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/FileFunctions/FileT...