Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Where not Exists blowing my mind

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:

778ebfc6fc.jpg

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?

1 Solution

Accepted Solutions
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

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)

View solution in original post

2 Replies
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

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);