LOADEntiteID FROM [An excel file...] (ooxml, embeddedlabels, tableis [Entités par groupe]);
EntiteSansGroupeTMP: LoadDistinct"Entite_Comptable_ID"asEntiteIDS wherenotexists (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.