Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Importing a CSV file, column headers not detected

Hello

I'm importing a CSV file into my QV app, but the column headings in the file are not being detected and QV is making default headings of @1 and @2.

I've attached the CSV file and the error. Does anyone know how to fix this?

Many thanks.

James

4 Replies
erich_shiino
Honored Contributor

Importing a CSV file, column headers not detected

I think you just have to select the correct option for headers (Embedded labels) when you go through the wizard to import your file:

The script should look like this:

LOAD split,

     SplitName

FROM

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

Regards,

Erich

christian77
Valued Contributor

Importing a CSV file, column headers not detected

Hi:

Labels.jpg

Not applicable

Importing a CSV file, column headers not detected

Hi James

while importing data from table files in the file wizard type u'll get an option of label try to select embedded labels instead of default none/explicit labels ...

thanks a lot

Bradd

Not applicable

Importing a CSV file, column headers not detected

Thanks for your answers! I had the same issue and it got solved.

Venkatesh

Community Browser