qlikview daily refresh delete the old record and take modified record

[Anonymous]

Hi Team

I have a requirement where i have the daily data loads. Suppose if the department of the employee id =1 changes from CS to IT.

Thus after the load it should show only the latest record.

Pfa the image table 1 coming as of now. Need data shown as in table 2.

Thanks in advance.

[arvind_patil]

Hi Sristi,

Please  find below it will serve your purpose:

Data:
SQL SELECT
           PrimaryKey,
           A,
           B,
           C
FROM DB_Table
WHERE ModifyDate >= $(vDate);

CONCATENATE

LOAD
           PrimaryKey,
           A,
           B,
           C
  FROM Data.qvd
  WHERE NOT exists (PrimaryKey);

Thanks,

Arvind Patil