Hi. In my extract I am loading a bunch of data from a database into a qlikview table. After the table is created I am storing it into a qvd. I'm running into an issue that every time I run the extract the data replaces the previous data into the qvd. Is there code that will add the new data to the qvd and retain the old data? Currently I am using STORE * FROM Table INTO Table.qvd. I figured there might be a different code that I could use to do this. Thanks.
Nope. A qvd file is basically a memory dump of a table from qlikviews in-memory database. It's not possible to incrementally store to a qvd file. But since it is a memory dump it will be written to disk very quickly. What you can do is incremental loading and store each incremental extract into a separate qvd. Of course you then have to load all qvd's into qlikview to get the complete table.
I have tried this technique, but for some reason it messes up my data model. It only works for the first qvd in the directory, and then for the other ones it seems like the joins and concatenations are not working. Any idea how I can fix this?
They definitely do because I am specifying the field names in the extract and the data model. Something is happening in the data model where it works for the first qvd, but doesnt for the other ones. I am using code in the data model like this: