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

Community Support
,
1

User-Agent: Workspace Webmail 5.15.9Message-Id: <20151029072108.85f80dae80d1d2f2e266ec6278e6cbe8.096f6de106.wbe@email07.europe.secureserver.net>From: “David Demner (AquaQ)” <david.demner>To: personal-kdbplus@googlegroups.comSubject: RE: [personal kdb+] Select a column mapped to a usernameDate: Thu, 29 Oct 2015 07:21:08 -0700Mime-Version: 1.0

Use #:


q)t:([]DAVID:();JOE:())
q)(1#upper .z.u)#t
DAVID
-----



2

Thanks David

3

Hmm sorry quick question, I am trying to pull a second column using that dynamic column name but not sure the syntax

exec Col from (`Col;upper .z.u)#t where upper .z.u=1b

results in type error

4

Never mind got using functional select.  Thanks.