Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Thanks so much.