Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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