Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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_dimperi
Valued Contributor II

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

Can you use

Load

*

From *.csv

This will concatenate all csv files

Not applicable

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

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_dimperi
Valued Contributor II

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

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_dimperi
Valued Contributor II

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

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...

Community Browser