1 Reply Latest reply: May 22, 2014 4:36 PM by Stefan Wühl RSS

    Script: Where not exists

    Simon Brulotte

      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.