Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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);