Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sibrulotte
Contributor III

Script: Where not exists

Hi,

I've got this working in a little environment:

LOAD  EntiteID
FROM
[An excel file...]
(
ooxml, embedded labels, table is [Entités par groupe]);

EntiteSansGroupeTMP:
Load Distinct  "Entite_Comptable_ID" as EntiteIDS
where not exists (EntiteID,"Entite_Comptable_ID") ;
SQL select
"Entite_Comptable_ID"
FROM a source.GL.vCharte_Comptable_Avec_Descr;

I get a sweet table with all my EntiteID in the GL chart of account that do not exist in the excel file mapping the EntitiID with a group.

Now I get this in my main script. Put it before I load a complete Chart of accounts, but after I loaded the excel file.

I get an empty table...

I know it's because my EntiteID exists in my complete chart of accounts, but I thought that compiling this table with a where not exists BEFORE compiling the complete chart of accounts would allow me to have not exists of EntiteID from strictly the excel file...

Take a look at the structure attached, you might unerstand what I am talking about.

1 Reply
MVP
MVP

Re: Script: Where not exists

Simon, I think the relevant script snippet would be helpful here.