Trying to use each right

Community Support
,
1

https://learninghub.kx.com/forums/topic/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

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

 

3

Thank you! this worked