topic incremental qvd in QlikView https://community.qlik.com/t5/QlikView/incremental-qvd/m-p/224109#M76562 <HTML><HEAD></HEAD><BODY><P>what is the identificator for an update?</P><P>Timestamp, recordno, flag?</P><P>As an idea:</P><P>Oldnumbers:</P><P>load recnumber from data.qvd; // load loaded recordnumbers</P><P>Tab:</P><P>load * from sourcefile where not exists (recnumber); // load only record where recordnumber not exists</P><P>load * from data.qvd; //concatenate load old datas into memory</P><P>store * from Tab into data.qvd; //store old an new data into file</P><P>drop table Tab; //clear memory</P><P>You can also do this with record timestamp</P><P>or if the record number is continuing: where recordnumber &gt; max(recordnumber.old)</P><P>Regards</P></BODY></HTML> Wed, 15 Dec 2010 15:50:00 GMT martinpohl 2010-12-15T15:50:00Z incremental qvd https://community.qlik.com/t5/QlikView/incremental-qvd/m-p/224108#M76561 <HTML><HEAD></HEAD><BODY><P>how will i use incremental qvd because my table need to update on daily basis.please let me know</P></BODY></HTML> Wed, 15 Dec 2010 14:33:10 GMT https://community.qlik.com/t5/QlikView/incremental-qvd/m-p/224108#M76561 2010-12-15T14:33:10Z incremental qvd https://community.qlik.com/t5/QlikView/incremental-qvd/m-p/224109#M76562 <HTML><HEAD></HEAD><BODY><P>what is the identificator for an update?</P><P>Timestamp, recordno, flag?</P><P>As an idea:</P><P>Oldnumbers:</P><P>load recnumber from data.qvd; // load loaded recordnumbers</P><P>Tab:</P><P>load * from sourcefile where not exists (recnumber); // load only record where recordnumber not exists</P><P>load * from data.qvd; //concatenate load old datas into memory</P><P>store * from Tab into data.qvd; //store old an new data into file</P><P>drop table Tab; //clear memory</P><P>You can also do this with record timestamp</P><P>or if the record number is continuing: where recordnumber &gt; max(recordnumber.old)</P><P>Regards</P></BODY></HTML> Wed, 15 Dec 2010 15:50:00 GMT https://community.qlik.com/t5/QlikView/incremental-qvd/m-p/224109#M76562 martinpohl 2010-12-15T15:50:00Z