Blank cells instead of data

[Anonymous]

Hello everyone,

In the editor script , I load various csv files, but for 2 of them there is a loading problem.

Some  cells of the colomn @5 are blank but in the csv there is a value.

I don't understand from where comes the error as the script is extremly simple.

Here the script:

LOAD @1 , @2 , @3 ,  @4 , @5 , @6
FROM [files.csv]
(txt, utf8, explicit labels, delimiter is ';', msq);

Do you know what is causing this?

Many thanks,

Elodie

[Mark_Little]

Hi Elodie,

I would guess at a special character in the field,

Can you please share some sample data?

Or at least an example of the data held in a field that isn't loading?

Marl

[Anil_Babu_Samineni]

I believe, In your data source there is some null values in specific fields of your excel. That is why it constant as parameter of each field in to @...