Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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