-
Trying to use each right
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.
-
2 Replies
-
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
-
Thank you! this worked
Log in to reply.