CODEWITHSUNDEEP
kdb+
Rezzy
Rezzy

Reputation: 141

How to splay a column of type dictionary

I have a column in my table whose values that are dictionaries. The type in the meta of that column is " ".

I want to know how to splay this table. When I try to splay it, I get a type error. I am aware only vectors can be splayed, however, I have seen a table where a column holds dictionaries splayed before, so I know it's possible, but I am not sure how it is done.

Upvotes: 0

Views: 181

Answers (1)

Matt Moore
Matt Moore

Reputation: 2775

Dictionaries are only supported in kdb version >3.6.

If you are running 3.6/4.0, double check you are enumerating the table for splay.

`:path/to/table set .Q.en[`:hdb;table]

If <3.6 json string is a good alternative although not recommended on large tables as .j.k is slow.

Upvotes: 3

Related Questions