Discussion Board for collaboration related to QlikView App Development.
Can any one tell me how to perform incremental load when there is no date feild but key feild is present?????????
Plz explain with example in case
Unless until you have some timestamp to check for latest updated data, you can't implement incremental load with key field only. Possibly you can handle the Insert Only and Delete Only cases with Key field, but that might not be really incremental.
If u dont hv Date field..
Store Example into Example.qvd;
In second time load it will clear old qvd & generate new qvd..
without date it will refresh qvd..no incremental.
That does not matter as long as you have a unique identifier. ID. the id's should be ascending. The principle is similar to when you have a timestamp: identify your delta and load them.