2 Replies Latest reply: Jan 26, 2017 9:58 AM by Sunny Talwar RSS

    Where not Exists blowing my mind

    Evgeny Stuchalkin

      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?