topic Re: Incremental Load Failing in QlikView

Incremental Load Failing

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I had implemented incremental load few days ago it worked fine for the first two days then it has failed all over. Instead of loading all six tables outlined in the script it only loads the first table. Please provide help it's an absolute must for my project.

Thanks in advance,

Re: Incremental Load Failing

syukyo_zhu — Tue, 15 Mar 2016 14:57:48 GMT

if you use concanate and you don't get any data from your first table "CustomerCuration", your reload will be failed.

check this load

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration

Where updatedate > '$(vLastRunTime)';

Re: Incremental Load Failing

Tue, 15 Mar 2016 15:03:25 GMT

Thanks for the reply, my understanding is in order for one to implement an incremental load one must use concatenate. Is there any other way I can do a insert and update incremental load?

Thanks,

Re: Incremental Load Failing

syukyo_zhu — Tue, 15 Mar 2016 15:16:51 GMT

Try this

Tmp_table:

SQL SELECT *

FROM yourtabledatabase

where yourdate >= '$(v_date_min)'

IF FileSize ('$(vRepxxx)\xxxx\yourqvd.qvd') > 0 then

Concatenate (Tmp_table)

LOAD

From [$(vRepxxx)\xxxx\yourqvd.qvd] (qvd)

Where

yourdate < Date#('$(v_date_min)', 'YYYYMMDD')

not exists (yourkey)

;

ENDIF

STORE yourqvd into [$(vRepxxx)\xxxx\yourqvd.qvd] (qvd);

Re: Incremental Load Failing

Tue, 15 Mar 2016 15:52:45 GMT

Thanks Xia!!!!!!