Incremental Load on QVD

[zahidrahim_ocp]

Dear Experts,

I have generated few QVD against few source tables and make dashboard for a given date. Now i want to setup incremental loads on these QVDs in Qlik Sense.

Please guide and help with step by step instructions as i am doing it for the first time.

Regards,

Zahid Rahim

[juraj_misina]

Hello Zahid,

BeginningThisExecTime can be initiated as

LET BeginningThisExecTime = Now();

The LastExecTime is trickier and you have several options, but in a most simple scenario you could call this line at the end of script:

LET LastExecTime = $(BeginningThisExecTime);

For the very first run you can either set it to some value (e.g. AddYears(Today(), -1) to retrieve data for last year) or if you already extracted some data, then you can use

LET LastExecTime = ReloadTime();

which would return a timestamp at which the last script run finished.

To be on the safe side, you should find out maximum last_update_date, assign it to LastExecTime variable and start from there.

[zahidrahim_ocp]

Below script keep me giving error:

The following error occurred:

Connector reply error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: missing expression

Can you please correct me what and where is wrong?

LET MAX_LUD = FieldValue('LUD') ;

[QV_Table]:

SQL SELECT Id,

    TrDate,

    Name,

    Amount ,

    LAST_UPDATE_DATE

FROM apps.qlik_inc_load

WHERE last_update_date > $(MAX_LUD);

[juraj_misina]

Hello Zahid,

I'm not an Oracle expert, but from the script you posted there are two options:

- last_update_date is upper case in select, but lowecase in where condition. Is this ok?

- does the variableMAX_LUD contain a valid value in correct format? SQL servers tend to be quite picky with dates.

[tajmohamed30]

Hi Zahid,

Please make sure you have access to DB and can fetch data in normal DB load.