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.
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