Incremental Load

[#1]

Hi,

I am trying to write an incremental load statement however my where clause is failing me. Could you kindly guide me on what I might be doing wrong:

Data_2014Q3update:

LOAD * FROM

(qvd);

SQL Select *

FROM 'Data_2014Q3update'

WHERE [Vendor Name] <> 'ABC, INC'

AND Year <> 2013;

Thank you!

[#2]

Massimo,

I am using QVD (QlikView Db).

Both options did not work for me!

[maxgro]

the script in bold isn't an extraction from a qvd

// this is from qvd

Data_2014Q3update:

LOAD * FROM

(qvd);

// this from a db

SQL Select *

FROM 'Data_2014Q3update'

WHERE [Vendor Name] <> 'ABC, INC'

AND Year <> 2013;