Get Column Headers in KDB/q Query

Question

How can i get the just the column headers of a table in KDB? Is there a special query for this? I am asking because when I pull the data from the table into python the column headers are lost. Thanks!

Did you try 'cols' command. ex: cols tbl – Rahul Nov 25 '15 at 06:18 — Rahul, Nov 25 '15 at 06:18
Which interface you're using to get kdb+ table to python? – Maciej Lach Nov 25 '15 at 08:02 — Maciej Lach, Nov 25 '15 at 08:02

score 2 · Accepted Answer · answered Nov 25 '15 at 14:54

If you're using one of the two regular python APIs for getting data from KDB, I think both implement a Flip class from which you can get the column names (usually there is an x which is an array of strings).

Otherwise cols tableName gives you list of symbols (which would be deserialized as an array of strings in python)

Get Column Headers in KDB/q Query

1 Answers1