Say I have a table with a column of lists
q)t:([]x:10?1.;y:10?`a`b`c;z:10#enlist`a`b)
q)t
x y z
----------------
0.1627662 b a b
0.6884756 b a b
0.8177547 a a b
0.7520102 b a b
0.1086824 c a b
0.9598964 c a b
0.03668341 a a b
0.6430982 a a b
0.6708738 b a b
0.6789082 a a b
How can I select for rows where y in z ?
select from t where y in'z
As z is a list of lists, you require an each. The ' acts as each-both. http://code.kx.com/q4m3/6_Functions/#672-each-both for more detail. Beware whitespace. https://groups.google.com/forum/#!forum/personal-kdbplus for more knowledgable advice.
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句