topic Re: Incremental Load in QlikView

Incremental Load

ecabanas — Thu, 21 May 2015 15:46:41 GMT

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

Re: Incremental Load

Tue, 04 Aug 2015 05:33:16 GMT

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

Re: Incremental Load

jonathandienst — Tue, 04 Aug 2015 05:51:59 GMT

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)