Getting New Records and Old Records

[sat_tok52]

Hi All,

In my Qvw there are 2 qvd's, one belongs to last week data (10,360 records), second qvd belongs to most recent data (10,380 records),additionally 20 records added in the most recent qvd. I would like to find out what are the new app names added in the most recent qvd.In both qvd's respective fields like app id, app name, app status

can you guys help me out which condition can i use to get old and new apps

[Anonymous]

you can check with your DateTimeStamp field, also you can use PrimaryKey to identify

see this:

Incremental Load in QlikView – Part1 | Learn QlikView

[maxgro]

pseudo code, app id is the pk, change the names according to your files

T:

load

     appid, appname, appstatus,

     appid as key,

     'old' as type

from last_week_file.qvd (qvd);

concatenate (T)

load

     appid, appname, appstatus,

     'new' as type

from this_week_file.qvd (qvd)

where not exists (key, appid);

drop field key;

store T into last_week_file.qvd (qvd);