mismatch

Community Support
1

This works:

q)t:(a:ab;b:0 1;c:“ab”)

q)show t,:(a:cd;c:“cd”)

a b c

a 0 a

b 1 b

c   c

d   d

Why this, which semantically you’d think it’s exactly the same thing, doesn’t work?

q)t:(a:ab;b:0 1;c:“ab”)

q)t:t,(a:cd;c:“cd”)

'mismatch

2

ideally , and ,: would have the same behaviour.
In the meantime, one workaround -

q)partialJoin:{x,$[count c:colsexcept cols y;cols#y,'count[y]#0#c#x;y]}

q)t:(a:ab;b:0 1;c:“ab”);t1:(a:cd;c:“cd”);(t,:t1)~partialJoin[t;t1]

1b

3

or more simply

partialJoin:{:x,:y}