Trying to use each right

[ekallivrousis]

t:([x:(1 2 3);y:(`x`y`z)]z:"abc")
l:`x`y`z!(2;`y;"b")
select from t where (2#l) ~/:flip value flip key t

Shouldnt the above code be showing the second row in table? instead i get nothing back.

[matt_moore · Accepted solution]

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

[ekallivrousis]

Thank you! this worked