sql - Append one table to another using kdb/q -

i have table that's got values, , append table one. columns in second table don't entirely match first.

please note using q/kdb+ language achieve this:

for example:

table 1

date typea typeb typec aggregate

dt1 b c abc

table 2

header1 header2

typea x

typeb y

typec z

i output be

table3

date typea typeb typec aggregate

dt1 b c abc

(null) x y z (null)

t:([]date:enlist 2014.01.01;typea:enlist `a;typeb:enlist `b;typec:enlist `c;agg:enlist `abc)  t2:([]header1:`typea`typeb`typec;header2:`x`y`z)  t uj enlist (!) . value flip t2  date       typea typeb typec agg -------------------------------- 2014.01.01     b     c     abc            x     y     z