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

[charles_upboy]

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

[robert_coen]

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_upboy]

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

在2021年3月18日星期四 UTC+8 上午2:10:56<rober...@aquaq.co.uk> 写道：

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