Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a qvw that loads daily qvd's. I would like for it to just add one day everyday rather than reload the entire period of time. Currently it reloads the last two weeks worth of individual qvd's. I attempted to do an add load, but that didn't work. Any help is appreciated.
What is the script you are using right now?
This is a simplified version of it.
FOR i = today()-15 to today()-1
LET FILE_Date = date($(i),'yyyyMMdd');
T1:
LOAD date, A, B, C
FROM QVD1$(FILE_Date).qvd
;
T2
LOAD date, A, B, D
FROM QVD2$(FILE_Date).qvd
;
NEXT i;
Try like this (just some steps that can be easily translated into QV script):
If you don't drop the resident table at the end, you'll have an updated internal table, whether you script runs every day or not (fail safe)
Best,
Peter
How would I do that in the script. Particularly your Step 5. I have been throw right into Qlikview and not very familiar with it. I am looking at just updating the internal table so I don't have to create more QVDs. The daily QVD is created every night for the day just ending so it is always a day behind, then this report runs after the latest QVD has been created. I tried ADD LOAD, but when I ran it, it overwrote the historic data and only added yesterday.