q kdb+ finding index of match elements using a list

Question

Say I have a list

b:1 1 2 3 4

and I want to find the location of the element in list b using another list

a:1 2

When I type in b in\ a, I got

11000b
00000b

where it should be

11000b
00100b

What is going on and how to get the desired answer?

Thanks in advance!

score 2 · Answer 1 · answered Feb 06 '18 at 17:24

2

You need to use each-right /:

q)b in/:a
11000b
00100b

With b in\a the first output is getting passed back in as b. Effectively:

q)1 1 2 3 4 in 1
11000b
q)11000b in 2
00000b

answered Feb 06 '18 at 17:24

score 0 · Answer 2 · edited Feb 27 '18 at 14:32

0

You can also use each-both ':

q)in[b]'[a]
11000b
00100b

edited Feb 27 '18 at 14:32

answered Feb 08 '18 at 22:07

2 Answers2