2022.04.19 04:32 PM
dont know what mistake im making here, will attach code and error below. have to find all the trades in the tradeContext table where exQuality is false (bad trades)
2022.04.20 09:19 AM - edited 2022.04.20 09:24 AM
Hello @conorn_7,
The assessment shows that you are getting a type error. Can you run 'meta' on table 'x' please?
What type should exQuality be? In your query, you are saying that exQuality is a symbol rather than a boolean.
Here in my example, you can see the metadata for my table and the 'type' error returned when I run a query expecting exQuality to be a symbol when it is in fact a Boolean.
Whereas, if I comply with the metadata for the table, expected results are returned:
Hope this helps,
Leah
2022.04.20 09:19 AM - edited 2022.04.20 09:24 AM
Hello @conorn_7,
The assessment shows that you are getting a type error. Can you run 'meta' on table 'x' please?
What type should exQuality be? In your query, you are saying that exQuality is a symbol rather than a boolean.
Here in my example, you can see the metadata for my table and the 'type' error returned when I run a query expecting exQuality to be a symbol when it is in fact a Boolean.
Whereas, if I comply with the metadata for the table, expected results are returned:
Hope this helps,
Leah
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.