Help with script

[OmarBenSalem]

Hi all, ( stalwar1‌),

I have 2 tables:

table1:

load * Inline [

dossier

AU1

AU2

TN

];

NoConcatenate

table2:

load * Inline [

dossier

AU1

TN

];

What I want to do is:

I want to compare fields in both tables, if I find a 'dossier' in table2 that begins with AU (AU1) I have to drop this field from table1.

So the final table would be only table1 (drop table2 once finished)

And table1 should contain : AU2 (not found in table2) and TN.

A help would be appreciated ; thanks,

[sunny_talwar]

May be this

Where not Exists(commessa, Dossier);

Where

commessa comes from the previous table

Dossier comes from the current table