kdb+ and q
Q+A on all things kdb+ database and the q language
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

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

Select a column mapped to a username

I have table with columns for users.ie. t:([]Dave:`$();Nick:`$())I am wondering how to dynamically select the column that matches the current username using .z.uI will have to consider string cases, using something like `$ssr[string .z.u;string .z.u;...

ISO-8601 (.h.iso8601)

Hi all,I noticed that .h.iso8601 is defined as following:k){$[^x;"";@[$"p"$x;4 7 10;:;"--T"]]}Since it converts everything to a timestamp, it give rise to values like "2015.10.29T00:00:00.000000000" with an input of 2015.10.29.This might be find for ...

Flying by New Contributor III
  • 0 replies
  • 0 kudos

scatter selection, transitive closure and state transition

Hi,Can anyone throw some light on how the features mentioned in the subject work ?They are present since K2, but couldn't find any documentation.The old K online help just shows the syntax:scatter selection matrix'transitive closure vector/ vector\st...

pahihu by New Contributor
  • 5 replies
  • 0 kudos