Import from csv

[arsenal1983]

Hi,

I need to import data from several csv files. The problem I've got is that there are character size in columns names for example in one file I have column 'Timestamp' while in another I have 'TimeStamp' is there any way to ignore the character size in script?

Luke

[YoussefBelloum]

Hi,

if you always load all the columns you can just do: LOAD *

but if you choose your columns, it is case sensitive

[juraj_misina]

Hi,

if the order of columns is alwasy the same (i.e. Timestamp/TimeStamp is always on the same position) you can set "no labels" and "header is 1 row" and then reference columns with
@1 as Field1,

@2 as Field2,

...