79785417

Date: 2025-10-08 11:48:46
Score: 1
Natty:
Report link

single column filtering, same as IS NOT NULL or IS NULL in SQL for KDB Q -

t:flip `a`b`c`d`e!flip {5?(x;0N)} each til 10

select from t where e <> 0N
a b c d e
---------
3 3   3 3
    5 5 5
7 7   7 7
      8 8
9     9 9

select from t where e = 0N
a b c d e
---------
0 0 0 0
  1
    2
4   4
      6
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Cameron Si