Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add data to qvd instead of replace it

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.

11 Replies
Not applicable
Author

We get an SAP table each night with the prior 7 days of data (LIKP_DELTA.QVD) and append the data to the main SAP(LIKP.QVD) table with:

LIKP:

load *,

VBELN As Key

From Q:\LIKP_DELTA.QVD (QVD);

Concatenate

load  * ,

'-' as Key

From Q:\LIKP_USA.QVD (QVD) where  NOT EXISTS(Key,VBELN);

drop field Key;

store * from LIKP into Q:\LIKP.QVD;

DROP TABLE LIKP;

Not applicable
Author

Thanks so much.