How to add all sym into one list? - KX Learning Hub

kdb+

How to add all sym into one list?

Posted by hzadonis369 on May 1, 2022 at 12:00 am

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

hzadonis369 replied 8 months, 1 week ago 2 Members · 2 Replies
2 Replies

hzadonis369

Member
May 1, 2022 at 12:00 am

scan: (,)t[`sym]

over: (,/)t[`sym]

thinking in Q.
Laura

Administrator
May 2, 2022 at 12:00 am

Join Over ,/ is of course raze, so raze t`sym would do nicely.

Watch Out: scan is a q keyword and you cant assign it a value.

Log In to Reply

Log in to reply.