Problem with csv loading

[#1]

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

[kaushiknsolanki]

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

[hic]

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

HIC

[#4]

Thank you to all. It works