Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
May be this
Where not Exists(commessa, Dossier);
Where
commessa comes from the previous table
Dossier comes from the current table