topic Re: Update a resident table in QlikView

Update a resident table

Anonymous — Mon, 12 Sep 2016 23:46:35 GMT

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.

Re: Update a resident table

sunny_talwar — Tue, 13 Sep 2016 00:27:15 GMT

What is the script you are using right now?

Re: Update a resident table

Anonymous — Tue, 13 Sep 2016 01:41:07 GMT

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

;

LOAD date, A, B, D

FROM QVD2$(FILE_Date).qvd

;

NEXT i;

Re: Update a resident table

Peter_Cammaert — Tue, 13 Sep 2016 07:19:03 GMT

Try like this (just some steps that can be easily translated into QV script):

Load History QVD (if it exists)
Pick latest date from history file or set latest date to some "first" date if no history
For vDay = LatestDateFromHistory + 1 to Today()
Assemble correct file name based on vDay value
Add records from this QVD to resident table
Next
Store resident table into history QVD

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

Re: Update a resident table

Anonymous — Tue, 13 Sep 2016 16:20:14 GMT

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.