Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Look OK to me also. You have blanks in COD_STATO, though.
HIC
Thank you to all. It works