How to solve rejected records issues for csv

[RAJ6]

Hi Folks,

I have 76012 rows are there in my csv. In my csv have rejected records. so I fixed string datatype for all the columns. Then I used tconvertType component for string to double for particular column. I have tried but again six records rejected. Is there any other way to solve this issue. How to solve rejected records issues.Please kindly share your information.

[TRF]

Hi,
As soon as a column contains a value that can't be converted to the desired datatype, the record will be rejected.
If you want to avoid this, you need to check the value by yourself then convert to null or 0 if the content doesn't match with the standard conversion rules.
tMap or tJavaRow may help for that.

[RAJ6]

can you tell me? How to solve that issues using tMap or tJavaRow?

[Théo_Cap]

You can use a tReplace before the tConvert.