KX Community

david_demner

You can pass multiple columns into xasc`time`pos xasc talso, sorting is stable so you can go`time xasc `pos xdesc tfailing those, you can massage your indices something like t (exec i from t where 500=abs pos),exec i from t where 500<>abs posto put a...

david_demner

X-Originating-IP: 174.7.132.159User-Agent: Workspace Webmail 5.16.0Message-Id: <20160101200302.85f80dae80d1d2f2e266ec6278e6cbe8.4a08ca37d3.wbe@email07.europe.secureserver.net>From: "David Demner $AquaQ$" To: personal-kdbplus@googlegroups.comSubject...

david_demner

X-Originating-IP: 174.7.132.159User-Agent: Workspace Webmail 5.16.0Message-Id: <20160101141535.85f80dae80d1d2f2e266ec6278e6cbe8.09ddc238fa.wbe@email07.europe.secureserver.net>From: "David Demner $AquaQ$" To: personal-kdbplus@googlegroups.comSubject...

david_demner

X-Originating-IP: 174.7.132.159User-Agent: Workspace Webmail 5.15.9Message-Id: <20151029072108.85f80dae80d1d2f2e266ec6278e6cbe8.096f6de106.wbe@email07.europe.secureserver.net>From: "David Demner $AquaQ$" To: personal-kdbplus@googlegroups.comSubject...

david_demner

X-Originating-IP: 174.7.128.233User-Agent: Workspace Webmail 5.15.9Message-Id: <20150831110650.85f80dae80d1d2f2e266ec6278e6cbe8.3dd5974ce5.wbe@email07.europe.secureserver.net>From: "David Demner $AquaQ$" To: personal-kdbplus@googlegroups.comSubject...

david_demner

No You have to loop through allpaths and update that way. Something like this [totally untested] code: {(` sv x,`price) set exec ?[sym=xxx;2;1]*price from x}peach allpaths[`:.;`tableName] From: personal-kdbplus@googlegroups.com [mailto:personal-kdbp...

david_demner

You want . (index/apply) https://code.kx.com/q/ref/apply/ and /: (each-right) https://code.kx.com/q/ref/maps/ and raze https://code.kx.com/q/ref/raze/ Combining these three to end up with: q)requests:((2021.06.07;2021.06.09;53696;`Sent);(2021.06.12;...

david_demner

Have you set QHOME?export QHOME=/qbut yeah the error is a bit weirdFrom: personal-kdbplus@googlegroups.com on behalf of neethakdb@gmail.com Sent: August 20, 2016 1:07 AMTo: Kdb+ Personal DevelopersSubject: [personal kdb+] KDB+ installation on Linux ...

david_demner

Your hdb is probably missing the sym file=FD. Is there a sym variable defin= ed? key`:sym `sym in key`. How did you save the tables? If you used .Q.en[`:.] kdb probably made the s= ym file in the rdb root not the hdb root. You'd have to use .Q.en[`:h...

david_demner

If you always want 4 digits string`long$x*100 If you want 4 digits or more string[x*100]except"." But if you have too many digits you have to be quite careful with the \P setting. E.g.: q){string`long$x*100}46.3 "4630" q){string[x*100]except"."}46.3...

KX Community

User Statistics

User Activity

Re: [personal kdb+] How can I create a conditional sort?

RE: [personal kdb+] unique index

RE: [personal kdb+] optimize ungroup columns operation in kdb

RE: [personal kdb+] Select a column mapped to a username

RE: [personal kdb+] peach type error

Re: Question about fncol function in dbmaint

Re: Function within a function

Re: KDB+ installation on Linux error 'No such file or directory'

Re: Can we have HDB table without sym column?

Re: removing decimal point from a number/ converting float to long