Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kumarreddy257
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