Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello fellow Qlikviewans,
I have the following syntax which takes data from my FUM QVD every month. Now instead of the new data overwriting what I already have in the below table, I want the new data to be appended to the bottom instead...can someone PLEASE let me know how to script this as I'm pulling my hair out?!!
FUM:
LOAD [Bid Price],
DOB,
[Fund Name],
[Fund No],
[Fund Value],
[Policy Number],
[Scheme Name],
[Scheme Number],
Sex,
Units,
[Policy Status],
[Valuation Date]
FROM
(qvd)
Chaps....thanks for the help and links to documents etc.
I've just finished building the QVD creator and it works an absolute treat, so, thanks once again.
Hi Mate,
Let me make sure if I have understood the requirement. You wanted to load only new data from QVD instead of all the historical data... is this right? If yes, I would recommend using functions like RowNo() and RecNo() inyour QVD Load Script. Then you can store the most recent RowNo() or RecNo() ina script variable. Once you have this variable in your load script you can do the conditional load by using the “Where” clause. This way you are always loading the most recent data.
I hope this helps!
Good luck!
Cheers - DV
Hello mate,
Thats not quite right due to the way the data is set up, let me explain a bit further:
I have a DB which holds the current months FUM (Funds Under Management) data (about 500,000 records each month). The DB doesn't hold historical data as there's too much for Access to handle, therefore all I'll ever be loading to the QVD is the latest months worth of data.
That means I basically want to take everything from the QVD and append it to the bottom of what I already have in my QVW table, does that make sense. The QVD will hold only new data each time it's refreshed.
Your case seems to be rather basic. Take a look to QlikView Reference Manual Section 25.7 Using QVD files for incremental load
It has very well written description of how to arrange incremental load. You will need a timestamp or any other key that would help you to identify rows that needs to be appended.
Unfortunately I do not have a Reference manual, I'll look to see if I can download one.
Also, I don't really need to pick certain rows as everything will need to come accross. I just can't figure out how to load it without overwriting the previous data.
Reference Manual usually comes with QlikView installation -- look for folder Documentation in QlikView folder (make sure you made complete install).
There're plenty of them in internet as well.
Also, I don't really need to pick certain rows as everything will need to come accross. I just can't figure out how to load it without overwriting the previous data.
Usually you need to load previous data from QVD file using LOAD, append new data from database using SQL SELECT and then write all together into the same QVD file using STORE.
Mate,
Here are the reference manual(s).
Meanwhile, I will look into my sample repository and I'll keep you posted.
Cheers - DV
Also, one more useful document on incremental loading.
Cheers - DV
Chaps....thanks for the help and links to documents etc.
I've just finished building the QVD creator and it works an absolute treat, so, thanks once again.