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

Community Support
1

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

2

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

3

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