topic Import from csv in QlikView

Import from csv

arsenal1983 — Tue, 20 Feb 2018 08:06:56 GMT

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

Re: Import from csv

YoussefBelloum — Tue, 20 Feb 2018 08:38:51 GMT

Hi,

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

but if you choose your columns, it is case sensitive

Re: Import from csv

juraj_misina — Tue, 20 Feb 2018 08:48:43 GMT

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,

...