Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can anyone assist?
Can you use
Load
*
From *.csv
This will concatenate all csv files
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.
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.
Another solution is using filetime() and get the max() on your csv file.