Incremental Load

[ecabanas]

Hi,

I just tunned a file to do an incremental load from a Analytics excel.

The problem is in the incremental Load script tab. As all the Analytics info has no key field, I would like to load the present day and present day - 1 info, just to have all the date up to date.

Any body can help to me with the script?

Many thank's

Eduard

[#2]

According to date u can add new data to the existing Qvd

first u have convert the date formate

let vupdatedate = peek('Anal_date)', -1, 'table name');

where Anal_date >= $(vupdatedate);

[jonathandienst · Accepted solution]

Something like this:

// Load recent data

Data:

LOAD ....

FROM ...xlsx (ooxml, ...)

Where Date = Today() Or Date = Today() - 1;

// Load past data from qvd

LOAD *

FROM .......qvd (qvd)

Where Date < Today() - 1;

// Update qvd

STORE Data Into .....qvd (qvd);

(Change the date field to the appropriate field name, and make sure that the date field is loaded as a proper Qlikview date and not as a string)