topic Re: Problem with csv loading in QlikView

Problem with csv loading

Thu, 11 Jul 2013 08:10:57 GMT

Hi to all, I'm facing a strange problem, I'm trying to upload a csv file with three column, all data are imported but there are several invalid column

I've attached the file looking at the table generated by the import there are several rows with null as ID_RICH (ID_RICH value is displayed in column DateID)

Here you are the script :

RICHIESTE_MANORD:

LOAD

@1 as ID_RICH,

@2 as DateId,

@3 as COD_STATO

FROM

RICH_MANORD5.csv

(txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);

Can someone help me to identify the problem.

Thank you in advance for your help.

Fabrizio

Re: Problem with csv loading

kaushiknsolanki — Thu, 11 Jul 2013 08:17:30 GMT

Hi,

Try this. Its working properly my side.

LOAD ID_RICH,
DATA_RICH,
COD_STATO
FROM
D\RICH_MANORD5.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Regards,

Kaushik Solanki

Re: Problem with csv loading

hic — Thu, 11 Jul 2013 09:53:56 GMT

Look OK to me also. You have blanks in COD_STATO, though.

HIC

Re: Problem with csv loading

Thu, 11 Jul 2013 09:56:58 GMT

Thank you to all. It works