Discussion board where members can get started with Qlik Sense.
I have created an incremental load, but it is loading the whole data when I reload.
Following is the script I am using for creating the incremental load:
LastUpdatedDate:LOADmax("DATE") as MaxDateFROM [lib://qvd/book.qvd](qvd);
Let varThisExec = Date(Now());
Let varLastExec = peek('MaxDate', 0, 'LastUpdatedDate');
LOADNAME,"DATE",IDFROM [lib://BOOK/Book1.xlsx](ooxml, embedded labels, table is Sheet1)
Where "DATE" >= '$(varLastExec)';
from [lib://qvd/book.qvd](qvd)where not Exists(ID);Inner Join
FROM [lib://BOOK/Book1.xlsx](ooxml, embedded labels, table is Sheet1);if '$(ScriptErrorCount)' = 0 then
Store incremented_table into [lib://qvd/book.qvd](qvd);
Let varLastExec = '$(varThisExec)';
pls help me.
The initial steps to get max date from the existing data is correct.
Post this you should create a IF statement which will check if new date is greater than date in the existing data then execute below script else exit script
and in the execution statements you should code like
Load * from new file;
Load * from OldFile;
Hope this helps.