KX Community

eohara

9. Queries – q-sql - Q for Mortals (kx.com) "Unlike in SQL, columns in the Select phrase do not actually exist until the final result table is returned. Thus a computed column cannot be used in other column expressions." You'll need two different sel...

eohara

Building real-time tick subscribers | White Papers | kdb+ and q documentation - Kdb+ and q documentation (kx.com) is a start

eohara

Could you try running this in command line, then starting a new q session? export PATH="/usr/bin/anaconda3/bin:$PATH"

eohara

Are you missing something on the left hand side of your = sign? Also, could you provide a few example rows of the table you're working with? Thanks

eohara

Might be best to deal with this in pieces q)(2;3)2 3q)(2;enlist 3)2,3 Here, the enlist is to prevent 2 and 3 concatenating into a simple list of longs. The difference in the final output is an extra level of enlisting: q)value each{x+y+z}[1;;],'enlis...

KX Community

User Statistics

User Activity

Re: select with assignment

Re: Ticker Plant

Re: Python not working in Q

Re: how does the query below work

Re: Why does this work: value each {x+y+z}[1;;],'enlist (2;enlist 3)