Removing rows from a keyed table

Community Support
1

Hello,
I have two keyed tables and I want to exclude any rows in table1 that key values match table2 keys

table1

©¬ col1 ©¬ col2 col3
a b c
d e f
g h i


table2

©¬ col1 ©¬ col2 col3
a b c
d x y
g h z

result

| ©¬ col1 | ©¬ col2 | col3
|
| — | — | — |
|
|
|
|
| d | e | f |
|
|
|
|

Any idea how I can get this?

Thanks

2

q){(keyexcept key y)#x}[t1;t2]

col1 col2 col3
d    e   f  
3

variations

q)(key t1) _ t

col1 col2 col3
d    e   f 

q){key[i]!valuei:where not key in key y}[t;t1]

col1 col2 col3
d    e   f  

q){2!(0!x)where not key in key y}[t;t1]

col1 col2 col3
d    e   f  

q)(where not t in t1)#t

col1 col2 col3
g    h   i  
4

Thanks Charles