Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.