exclude records from one table

[dcd123456]

Hello

We have a table that was loaded from an excel file

TAB1:

Zona	Field1	Field2	Field3	Num
A	12	3	usr1	1
B	4	6	usr2	1
C	2	7	usr3	1
D	7	7	usr2	1
E	1	1	usr1	1
F	4	5	usr5	1
G	6	7	usr2	1

we need exclude from the table TAB1 the records that have a value in Field3 that was in the table TAB2

TAB2:

Field3

usr1

the TAB2 also is loaded from an excel file.

any body know how i can exclude the records in Tab1 where the field3 = usr1 ???

thanks in advance for your help

regards

[rbecher]

Here we go:

TAB2:
LOAD * INLINE [
    Field3
    usr1
];

TAB1:
LOAD * INLINE [
    Zonal, Field1, Field2, Field3, Num
    A, 12, 3, usr1, 1
    B, 4, 6, usr2, 1
    C, 2, 7, usr3, 1
    D, 7, 7, usr2, 1
    E, 1, 1, usr1, 1
    F, 4, 5, usr5, 1
    G, 6, 7, usr2, 1
]
Where IsNull(Lookup('Field3','Field3',Field3,'TAB2'));

- Ralf

[dcd123456]

thanks for your answer, it works.

regards

dcd