indication of new data in table

[#1]

Hi

i create a table with country name ,date and status,  this table update every day and i want to create some kind of indication when i load the table with new country added as new , something like this

Any idea ?

Thanks

[swuehl]

Maybe load your historic data first, then load your current table and check with EXISTS() if the Country value is already present in the historic table:

Table:

LOAD date, country, 'done' as status // or set the status to done at any other place where appropriate

FROM Historic.qvd (qvd);

CONCATENATE (Table)

LOAD

     today() as date,

     country,

     'New' as status

FROM YourTableSource

WHERE NOT EXISTS(country);

STORE Table INTO Historic.qvd (qvd);

You can also look deeper into the concept of an incremental load, which could also handle updated and deleted records, e.g. here:

http://qlikviewcookbook.com/download/delta-load-template/