incremental load

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[Anonymous]

Thanks Gysbert. It is working fine