Incremental load when composite key

[#1]

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.

[#2 · Accepted solution]

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.

[Anuhyak1]

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