topic Re: Incremental Load in QlikView

Incremental Load

reshmakala — Fri, 20 Nov 2020 18:02:30 GMT

Hi guys!

I have a very simple incremental load script where I am trying to use NOT EXISTS. It gives me a "missing SELECT Keyword" error. Can anyone help me on this please?

My script:

IF NOT Alt(FileSize('Data.qvd'),0) >0 THEN

TRACE 'file doesnt exists';

Data:

LOAD Country,

Loc_Key

....

;

SQL SELECT

Country,

Loc_Key,

....

FROM "XYZ"

WHERE Country='USA';

STORE Data into Data.qvd(qvd);

ELSE

trace 'file exists';

Data:

LOAD * FROM Data.qvd(qvd);

Concatenate (Data)

LOAD Country,

Loc_Key

....

;

SQL SELECT * FROM (SELECT

Country,

Loc_Key,

....

FROM "XYZ"

WHERE Country='USA')

WHERE NOT EXISTS(Loc_Key);

STORE Data into Data.qvd(qvd);

ENDIF;

Re: Incremental Load

MK_QSL — Thu, 17 Sep 2015 15:21:21 GMT

Data:

LOAD * FROM Data.qvd(qvd);

Concatenate (Data)

LOAD

Country,

Loc_Key

....

WHERE NOT EXISTS(Loc_Key);

SQL SELECT * FROM

(SELECT

Country,

Loc_Key,

....

FROM "XYZ"

WHERE Country='USA');

Re: Incremental Load

reshmakala — Thu, 17 Sep 2015 17:09:49 GMT

Thank you!