importing data from csv file, problem when lots of columns are empty

[Nesrine1]

Hello everyone,

I m importing data from a csv file, i got lots of errors and when I invistigate I found that the problem is when there is many columns which are empty, I made the screen under to illustrate what I am talking about

Is there any solutions to this, do you thing it is something else the problem.

This is the recap of the import set

and i got 290 errors which are all like the line i screened above

Thank you for your help

Regards,

[Dr Atul G- LNG · Accepted solution]

Hi @Nesrine1 

Greetings!!

The error is due to transform map. You need to update your transform map to accept empty field ,also please check the errors in attached screen shot . Why this record is not store. May be colsec issue.

Open this record and check. 

[Nesrine1]

Thank you for your response

I reviewed the coalesce operation, and I identified that the issue was caused by leading zeros in the field, which were being removed

Regards