topic no update field &amp; no max id - is incremental load possible? in App Development https://community.qlik.com/t5/App-Development/no-update-field-amp-no-max-id-is-incremental-load-possible/m-p/2081211#M88676 <P>Hi everyone.</P> <P>I have a few tables I have created qvds for and&nbsp; now I want to perform incremental load on them.</P> <P>BUT...</P> <P>In my qvd for the fact table: there are multiple date fields, but no last update field. Also, for the certain field of submissionDate the ids seem to have a descending order , but the thing is not all ids have values for submissionDate. They might get one submissionDate or they might even not, so in that case on the next reload, i will have lost this data. Right?</P> <P>What would you suggest that I do?? Can I get the last reload time of the data and use this field instead?</P> <P>Should I just drop them and recreate them qvds every time? This worries me a bit though, because what about when the tables get really big?</P> <P>Thank you in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 07 Jun 2023 14:25:53 GMT ioannaiogr 2023-06-07T14:25:53Z no update field & no max id - is incremental load possible? https://community.qlik.com/t5/App-Development/no-update-field-amp-no-max-id-is-incremental-load-possible/m-p/2081211#M88676 <P>Hi everyone.</P> <P>I have a few tables I have created qvds for and&nbsp; now I want to perform incremental load on them.</P> <P>BUT...</P> <P>In my qvd for the fact table: there are multiple date fields, but no last update field. Also, for the certain field of submissionDate the ids seem to have a descending order , but the thing is not all ids have values for submissionDate. They might get one submissionDate or they might even not, so in that case on the next reload, i will have lost this data. Right?</P> <P>What would you suggest that I do?? Can I get the last reload time of the data and use this field instead?</P> <P>Should I just drop them and recreate them qvds every time? This worries me a bit though, because what about when the tables get really big?</P> <P>Thank you in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 07 Jun 2023 14:25:53 GMT https://community.qlik.com/t5/App-Development/no-update-field-amp-no-max-id-is-incremental-load-possible/m-p/2081211#M88676 ioannaiogr 2023-06-07T14:25:53Z