I have codes as below. Why the last line would fail? How to make it work? Thanks! t:([] c1:`a`b`a`c`b`c; c2:1 1 1 2 2 2; c3:10 20 30 40 50 60);select from t where c1 in enlist `a; // worksselect from t where c1 in `a`b; // works?[t;enlist (in;`c1;enl...
In the below code, I can understand the meaning of (<), but cannot understand the meaning of (';~:;<). Why line 3 keeps 4 rows, while line 4 keeps 6 rows? What is the meaning of "~:" here? t:([] c1:`a`b`c`d`e`f; c2:1 1 1 2 2 2; c3:10 20 30 40 50 60);...
tab:([] c1: til 10 ; c2:10 + til 10) /Both do not work ?[tab;til 10;(>;`c2;16)] ?[tab;til 10;(last `c2)]
Composition has many "weired" syntax . Are they overloads of adverbs ? Is '[f ff] overload of ' adverb Another example is '[;]/[(g;f;ff)]
I have a table created like below. t:([]c: 30 40 25 20 4 4; c1: 10 20 5 25 5 4) c2 is calculated Column (value from c1 or prev c2 is used based on evaluation). prev value is taken as 0 for first row / if not available Below are the calculations. c c1...
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.