Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue in incremental load script

Hello experts,

I am getting below in my test environment and it is working in Dev.

Inserts:

LOAD *

FROM

$(Vqvxpath)dim_account_inserts.qvx(qvx);

date_dim_account:

LOAD Max(account_record_updated_datetime) as dim_account_Maxdate

Resident Inserts;

LET VDate_dim_account = Peek('dim_account_Maxdate',0,'date_dim_account');

DROP Table date_dim_account;

STORE Inserts into $(Vqvdpath)dim_account.QVD(qvd);

DROP Table Inserts;

Updates:

LOAD *

FROM

$(Vqvxpath)dim_account_updates.qvx(qvx)

Where (account_record_updated_datetime >'$(VDate_dim_account)') ;

Concatenate

LOAD *

FROM

$(Vqvdpath)dim_account.qvd(qvd)

Where not Exists(account_key);

STORE Updates into $(Vqvdpath)dim_account.QVD(qvd);

   

DROP Table Updates;

Can anybody help me this one.

Regards,

kumar

0 Replies