I was trying to convert a column which has a dictionary datatype on a table to a separate table to fetch information from it easily. This works with a simple uj for me when the dictionaries have the same set of keys. E.g. is shown below, which gives me a table with column names x and y as each dictionary in the table had two of the same keys.

I was trying to convert a column which has a dictionary datatype on a table to a separate table to fetch information from it easily. This works with a simple uj for me when the dictionaries have the same set of keys. E.g. is shown below, which gives me a table with column names x and y as each dictionary in the table had two of the same keys.

In most kdb systems its typical to reload the hdb (l .) after any data persistence has occurred. With larger hdbs, this reload can sometimes be costly especially when there are multiple flat files.

In most kdb systems its typical to reload the hdb (l .) after any data persistence has occurred. With larger hdbs, this reload can sometimes be costly especially when there are multiple flat files.

I have a table called details which has 2 columns, person(s) and personData(dict)
the personData is basically a dictionary which holds all person information.

I have tables that contain events identified by a ts, a symbol and another symbol like column. The timestamps are not precise and I am trying to match via wj to get all possible matches within a time window.