Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator

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
Champion
Champion

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
Luminary Alumni
Luminary Alumni

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,

...