cancel
Showing results for 
Search instead for 
Did you mean: 

How to add all sym into one list?

hzadonis369
New Contributor III

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

2 ACCEPTED SOLUTIONS

hzadonis369
New Contributor III

scan: (,\)t[`sym]

over: (,/)t[`sym]

thinking in Q.

View solution in original post

SJT
Valued Contributor

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.

View solution in original post

3 REPLIES 3

hzadonis369
New Contributor III

scan: (,\)t[`sym]

over: (,/)t[`sym]

thinking in Q.

SJT
Valued Contributor

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.

hzadonis369
New Contributor III

Thanks. Yes, I just mentioned 2 methods(scan and over).