2022.04.05 08:58 AM
Whats good, Qbies.
I have 2 tables I'm trying to put together with a window join using `sym`time columns.
The output table comes through fine, but I go through the data and it's clearly mixing results from different symbols. What gives?
I've checked datatypes and everything seems in order, with `sym amounting to a "s" type in both tables.
Any help greatly appreciated!
2022.04.05 11:05 AM
update `p#sym from q
/ or
@[q;`sym;`p#]
/ may need to sort first if it isn't already
update `p#sym from `sym`time xasc q
2022.04.05 10:05 AM - edited 2022.04.05 10:06 AM
wj
requires parted attribute on sym column of 2nd table:
t and q are simple tables to be joined (q should be sorted `sym`time with `p# on sym)
2022.04.05 10:45 AM
Yeah, I took a look at aj but ultimately wj just better suites my needs.
So I've got the tables sorted ``sym ``time but seem to be missing on the `p# part (pun maybe intended).
How does one `p# a column in a table properly?
2022.04.05 11:05 AM
update `p#sym from q
/ or
@[q;`sym;`p#]
/ may need to sort first if it isn't already
update `p#sym from `sym`time xasc q
2022.04.05 11:48 AM
that was it, thanks!
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.