Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
Try adding (qvd) before Where statement
Concatenate LOAD *
FROM [Lib://QVD (win-lng2sl4osbd_qlik.acc)/companies.qvd]
(qvd)
Where not Exists(i_companyID);