If the tables have the same number of rows, you can use the function ^ (fill):
q)t: ( x: `a`b; y: 1 2)
q)u: ( z: “YN”)
q)t ^ u / works only when count[t] = count[u]
x y z
a 1 Y
b 2 N
This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.