Where not Exists blowing my mind

[evgeniystuchalk]

Hello! I have this code:

LOAD *;

SQL SELECT *

FROM amo.companies

WHERE i_lastModified>=$(vLastUpdate) and i_lastModified<$(vNow)

Concatenate LOAD *

FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd]

Where not Exists(i_companyID);

Inner Join SQL SELECT i_companyID FROM amo.companies;

If ScriptErrorCount = 0 then

store companies into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd] (qvd);

Let vLastUpdate = $(vNow);

End If

Problem in the red zone: when i'm trying to load this code, i have namless error:

if Where Not Exist condition removed, all works fine. i_companyID - field in QVD file. It exists, correctl named, and have data in it. Whata wrong?

[evgeniystuchalk · Accepted solution]

OMG, im just forget to write (qvd) after path to qvd file

so, that is correct: FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd] (qvd)

[sunny_talwar]

Try adding (qvd) before Where statement

Concatenate LOAD *

FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd]

(qvd)

Where not Exists(i_companyID);