topic Re: Getting New Records and Old Records in QlikView

Getting New Records and Old Records

sat_tok52 — Tue, 01 Dec 2015 11:28:40 GMT

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

Re: Getting New Records and Old Records

Anonymous — Tue, 01 Dec 2015 11:32:40 GMT

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

see this:

Incremental Load in QlikView – Part1 | Learn QlikView

Re: Getting New Records and Old Records

maxgro — Tue, 01 Dec 2015 12:52:56 GMT

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

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);