Hello, Currently, I would like to sort a partitioned table by its column colA and colB. I simple perform the following actions: { t:`colA`colB xasc select from `://; (`://;17;2;6) set t} for each dates However, the q service was killed occasionally d...
I have a table contains columns col1, col2. I want to prefix the content of each row in col1 as "col1#". Similarly for col2 as well. Is there anyway i can do with functional update query? Thanks
Two questions on function projection Firstly, how can I project a function to one with no args, i.e. deferred execution. fn: {[x] x+1}; Obviously fn[1] or fn @ 1 will invoke the function now. Is there a way without wrapping it in another fn? Secondly...
If you learned long ago to break problems into loops, writing vector solutions takes study and practice. (It is actually easier for students who have not previously learned a ‘scalar’ language.) Much more is possible than just replacing for-loops wit...
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...
