Discussion Board for collaboration on QlikView Scripting.
I have a location suppose c/files/
Here I have 4 files namely a.csv, b.csv, c.csv and d.csv
I want to check the time and date of the files in the drive and proceed the script only if the file has changed.
How do I check that?
The logic would be:
read file date and timestamp,
if file has changed, read the file, otherwise skip script execution.
Could someone suggest me an approach for that please.
Use the filetime function in the load script. filetime(filename)
For a big file, it takes lot of time. It actually reads all rows then returns time which is not as expected.
Is there a faster way to get the time?
Also I can use a variable to see the filetime, but how do I store it in a file that can be read to check if the file has changed or not.