Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
thanks for your answer, it works.
regards
dcd