stuck with incremental load

[ziabobaz]

Hi,

I am trying to make incremental load from Google Tables.

The source have data for rolling 7 days (each day the earliest DATE is removed and NEW day is added).

I need to load only NEW and UPDATED rows.

I inserted the script from the HELP file (without really knowing what it means..), but the script returns the error:

I somehow need to tell Qlik not to Concatenate those records which were already loaded before.

Any suggestions?

[ziabobaz · Accepted solution]

WHERE NOT Column2='cpc' AND NOT EXISTS(Date,Column1)

this one worked.