Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem with csv loading

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

Tags (2)
3 Replies

Re: Problem with csv loading

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

Employee
Employee

Re: Problem with csv loading

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

HIC

Image1.png

Not applicable

Re: Problem with csv loading

Thank you to all. It works

Community Browser