Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incremental qvd

how will i use incremental qvd because my table need to update on daily basis.please let me know

1 Reply
martinpohl
Partner - Master
Partner - Master

what is the identificator for an update?

Timestamp, recordno, flag?

As an idea:

Oldnumbers:

load recnumber from data.qvd; // load loaded recordnumbers

Tab:

load * from sourcefile where not exists (recnumber); // load only record where recordnumber not exists

load * from data.qvd; //concatenate load old datas into memory

store * from Tab into data.qvd; //store old an new data into file

drop table Tab; //clear memory

You can also do this with record timestamp

or if the record number is continuing: where recordnumber > max(recordnumber.old)

Regards