Discussion Board for collaboration on QlikView Scripting.
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 :
@1 as ID_RICH,
@2 as DateId,
@3 as COD_STATO
(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.
Try this. Its working properly my side.
LOAD ID_RICH, DATA_RICH, COD_STATOFROMD\RICH_MANORD5.csv(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Look OK to me also. You have blanks in COD_STATO, though.
Thank you to all. It works