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

59 views
Skip to first unread message

charles li

unread,
Mar 17, 2021, 12:46:39 PMMar 17
to Kdb+ Personal Developers
how to load csv into a table and make it keyed at the meantime, thanks

Robert Coen

unread,
Mar 17, 2021, 2:10:56 PMMar 17
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

charles li

unread,
Mar 18, 2021, 5:46:19 AMMar 18
to Kdb+ Personal Developers
thanks, I now use xkey, it's more flexible
Reply all
Reply to author
Forward
0 new messages