Re: Trying to use each right

[matt_moore]

Take a look at what each part of the where clause looks like:

// this is a dictionary 
q)2#l x| 2 y| `y 
// and this is a nested list of your x and y columns with no rows matching above 
q)flip value flip key t 1 `x 2 `y 3 `z

To correct, just key t

q)select from t where (2#l) ~/: key t 
x y| z 
---| - 
2 y| b