topic Re: How Delete work's in Insert, Update & Delete method of Incremental Load? in QlikView

How Delete work's in Insert, Update & Delete method of Incremental Load?

amars — Tue, 12 Apr 2011 11:23:47 GMT

Hi all,

In Insert, Update & Delete method of Incremental load, I couldn't understand how Delete work's. Please if any one could tell me that? As per the reference manual

Script example:

Let ThisExecTime = Now();

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

But where it has code for Delete?

Thanks In advance.

How Delete work's in Insert, Update & Delete method of Incremental Load?

Tue, 12 Apr 2011 12:44:06 GMT

Hi Amar,

the inner Join method was used to remove the deleted records from the QVD file.

inner join will return only the common records in both the table.

How Delete work's in Insert, Update & Delete method of Incremental Load?

amars — Tue, 12 Apr 2011 12:55:10 GMT

Hi Gopinathan,

Can u explain in brief, how the inner join will remove the deleted records.

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

Thanks in advance.

Re: How Delete work's in Insert, Update & Delete method of Incremental Load?

SanjeevR — Wed, 21 Jun 2023 12:42:18 GMT

@amars Good Day, Did you ever get a solution to this query as I have the same issue because my inner join is not deleting the records.