2022.04.30 11:19 PM
Hi, Masters:
I have a table with sym field, for example:
q)show t:([]sym:(1+5?5)?\:5?`3)
sym
----------------
,`ceo
`edc`edc`edc`apa
`mlf`ceo`ijl
`apa`apa`mlf
,`mlf
How to add each sym and make it be a list, such as: `ceo`edc`edc`edc`apa`mlf`ceo`ijl`apa`apa`mlf`mlf ?
Thanks
2022.05.01 09:06 AM
2022.05.02 03:04 AM
Join Over ,/
is of course raze
, so raze t`sym
would do nicely.
Watch Out: scan
is a q keyword and you can’t assign it a value.
2022.05.01 09:06 AM
scan: (,\)t[`sym]
over: (,/)t[`sym]
thinking in Q.
2022.05.02 03:04 AM
Join Over ,/
is of course raze
, so raze t`sym
would do nicely.
Watch Out: scan
is a q keyword and you can’t assign it a value.
2022.05.02 06:36 AM
Thanks. Yes, I just mentioned 2 methods(scan and over).
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.