I have to use not like operation in KDB + query but do not know how exactly to use it. I am able to use like operator i.e. http://kdbserver:8001/?select from orderDetails where symbol like "X*" this query successfully gives the results.
How to use/implement not like for same query ?
select from orderDetails where not symbol like "X*"
For selecting the orders which are not like any of the patterns e.g. selecting the orders which are neither X* nor *Z
select from orderDetails where not any symbol like/:("X*";"*Z")
In kdb,
select col1, col2 from tabel where cond, cond should be a boolean list. like return a boolean list and not can flip a boolean list
