Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Not able to load csv file in qv version 12.10.1 SR1

Hi All

I am newbie to qv and I am trying to load a csv file to QV, by using the Ctrl + E command, selecting the file as given in examples in this portal. After I add the .csv file I am trying to insert the Table Object, but nothing shows like the column names of the csv etc. I have seen threads where people have cited problem with the version, how can I get around this.

I am attaching the csv file too. Any help is appreciated

1 Reply
Highlighted

Re: Not able to load csv file in qv version 12.10.1 SR1

I have the same version of QlikView and don't seem to have any issue loading the data using the following script

Table:

LOAD id,

    ident,

    type,

    name,

    latitude_deg,

    longitude_deg,

    elevation_ft,

    continent,

    iso_country,

    iso_region,

    municipality,

    scheduled_service,

    gps_code,

    iata_code,

    local_code,

    home_link,

    wikipedia_link,

    keywords

FROM

[..\..\Downloads\airports.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);