Hi Xinyu,Normally in q, columns are referenced using their name, the
same as you have done in your delete statement:select s,qty from spwill
return the same as what you're getting with delete.Do you still need to
access the columns via a numerical in...
Hi Xinyu,The following uses two select statements to generate a table
for each sym, then combines them using a union join. Finally the data is
re-sorted by ascending time order.`time xasc (select
utc_datetime,sym1:sym,price from trade where sym=`ESH6...
Hi Josh,Here is a generic method, for a table with any number of keys:
t:([date:1 1 1 2 2; sym:`A`B`D`B`C] pl:5?1f)tdate sym| pl--------|
---------1 A | 0.13304351 B | 0.89996251 D | 0.25712 B | 0.06518492 C |
0.425422pad:{0^k!x k:flip keys[x]!flip (...
