Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
WHERE NOT Column2='cpc' AND NOT EXISTS(Date,Column1)
this one worked.