Incremental load from excel

[tommyl]

Hello experts,

I cannot make incremantal load(Insert , update, delete). I do as Qlik help directs but i dont understand the problem. Here is my script :

Let ThisExecTime = Now();
IncLoad:
LOAD
    id,
    name,
    surname,
    hiveTime
FROM [lib://AttachedFiles/IncLoad.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE hiveTime >= $(LastExecTime)
AND hiveTime<= $(ThisExecTime);
Concatenate LOAD
	id,
    name,
    surname,
    hiveTime
FROM IncLoad.QVD
WHERE NOT EXISTS(id);
Inner Join load id from [lib://AttachedFiles/IncLoad.xlsx];
If ScriptErrorCount = 0 then
STORE IncLoad INTO IncLoad.QVD;
Let LastExecTime = ThisExecTime;
End If
Store IncLoad into 'lib://LOYALTY/IncLoad.qvd'(qvd);

Thank you for your help,

Regards,

[martinpohl]

do you get a script error or some data are missing?

I think

Inner Join load id from [lib://AttachedFiles/IncLoad.xlsx];

is the problem. with this line you reduce the datas, concatenated in load before to those datas who are in the xlsx-file.

delete this line.

Regards