how to load csv into a table and make it keyed at the meantime, thanks

75 views

Skip to first unread message

unread,

Mar 17, 2021, 12:46:39 PM3/17/21

to Kdb+ Personal Developers

how to load csv into a table and make it keyed at the meantime, thanks

unread,

Mar 17, 2021, 2:10:56 PM3/17/21

to Kdb+ Personal Developers

One way of keying the first column of a table as they're being loading in is to use

1!("***";enlist",") 0: `:path/to/example.csv
Alternatively you can use xkey to speicify which column you want keyed

`column xkey ("***";enlist",") 0: `:path/to/example.csv

unread,

Mar 18, 2021, 5:46:19 AM3/18/21

to Kdb+ Personal Developers

thanks, I now use xkey, it's more flexible

Reply all

Reply to author

Forward

0 new messages