topic Importing a CSV file, column headers not detected in QlikView

Importing a CSV file, column headers not detected

Tue, 07 Jun 2011 15:10:21 GMT

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

Importing a CSV file, column headers not detected

erichshiino — Tue, 07 Jun 2011 15:13:46 GMT

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

Importing a CSV file, column headers not detected

christian77 — Tue, 07 Jun 2011 15:15:40 GMT

Hi:

Importing a CSV file, column headers not detected

Tue, 07 Jun 2011 15:27:33 GMT

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

Importing a CSV file, column headers not detected

Wed, 15 Feb 2012 16:48:23 GMT

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

Venkatesh