Script: Where not exists

sibrulotte — Thu, 22 May 2014 20:28:38 GMT

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.

Re: Script: Where not exists

swuehl — Thu, 22 May 2014 20:36:22 GMT

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

topic Re: Script: Where not exists in QlikView

Script: Where not exists

Re: Script: Where not exists