topic Re: incremental load in QlikView

incremental load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am doing incremental load and here is my script

LET Vqvdpath = 'D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Reports\';

Inserts:

SQL SELECT *

FROM "Stage_Three_DW".dbo."dim_geography";

date_dim_geography:

LOAD Max(geography_updated_datetime) as dim_geography_Maxdate

Resident Inserts;

LET VDate_dim_geography = Peek('dim_geography_Maxdate',0,'date_dim_geography');

DROP Table date_dim_geography;

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

DROP Table Inserts;

Updates:

load * From Where geography_updated_datetime >$(VDate_dim_geography);

SQL SELECT *

FROM "Stage_Three_DW".dbo."dim_geography";

Concatenate

LOAD *

FROM

$(Vqvdpath)dim_geography.qvd(qvd)

Where not Exists(geography_key);

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

DROP Table Updates;

I am getting below error

Please give me any suggestions

Regards,

Kumar

Re: incremental load

Gysbert_Wassenaar — Mon, 21 Mar 2016 14:38:38 GMT

Updates:

load * From Where geography_updated_datetime >$(VDate_dim_geography);

SQL SELECT *

FROM "Stage_Three_DW".dbo."dim_geography";

Remove the From. You're using a preceding load where the data comes from the SQL SELECT so you don't need a FROM to specify where the data comes from. By using the From Qlikview treats what follows as the name of a source file.

Re: incremental load

Anonymous — Tue, 22 Mar 2016 07:36:25 GMT

Thanks Gysbert. It is working fine