Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arsenal83
Contributor

Import from csv

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

2 Replies
YoussefBelloum
Esteemed Contributor

Re: Import from csv

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
Valued Contributor

Re: Import from csv

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,

...

Community Browser