Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi:
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
Thanks for your answers! I had the same issue and it got solved.
Venkatesh