(q/kdb+) Create a table with string column

Question

I can create the following table in kdb using

([]idx:0,1,2;str:"a","b","c")

idx str
0   a
1   b
2   c

but I cant do for instance

([]idx:0,1,2;str:"aa","bb","cc")

I would like to get

idx str
0   aa
1   bb
2   cc

What am I doing wrong when creating this string column?

terrylynch · Accepted Answer · 2019-03-22 18:03:43Z

3

Use braces and semi-colons rather than commas to separate list items:

q)([]idx:(0;1;2);str:("aa";"bb";"cc"))
idx str
--------
0   "aa"
1   "bb"
2   "cc"

answered Mar 22, 2019 at 18:03

terrylynch

14k1 gold badge15 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1