topic Incremental load when composite key in QlikView

Incremental load when composite key

Wed, 24 Aug 2011 08:04:30 GMT

I am trying to do an incremental load for a table having composite key. I create a primary_key while loading the incremental portion and also create a primary_key while loading from the qvd. The where not exists(primary_key) check gives the 'Field not found' error.

$(tableName):

LOAD name&surname as $(primaryKeyColumn),

name,

surname,

`modified_date`;

SQL SELECT *

FROM `qv_test`.names

Where $(lastModifiedColumn) > '$(startDate)' and $(lastModifiedColumn) < '$(endDate)';

Concatenate ($(tableName))

LOAD name&surname as $(primaryKeyColumn),

name,

surname,

`modified_date`

From $(qvdPath)$(tableName).qvd (qvd)

Where not (Exists($(primaryKeyColumn)));

Could you help me with how to get incremental load when there is a composite key.

Incremental load when composite key

Wed, 24 Aug 2011 08:26:44 GMT

Hi,

The second load statement should be as follows:

Concatenate ($(tableName))

LOAD name&surname as $(primaryKeyColumn),

name,

surname,

`modified_date`

From $(qvdPath)$(tableName).qvd (qvd)

Where not Exists($(primaryKeyColumn),name&surname);

Cheers.

Re: Incremental load when composite key

Anuhyak1 — Fri, 30 Oct 2020 23:24:38 GMT

How do you perform inner join based on which key you have used to remove duplicates for delete logic. Can you the qlikview script file please if possible