topic Re: How to solve rejected records issues for csv in Talend Studio

How to solve rejected records issues for csv

RAJ6 — Wed, 06 Dec 2017 13:00:09 GMT

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.

Re: How to solve rejected records issues for csv

TRF — Wed, 06 Dec 2017 14:18:27 GMT

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.

Re: How to solve rejected records issues for csv

RAJ6 — Thu, 07 Dec 2017 13:17:01 GMT

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

Re: How to solve rejected records issues for csv

Théo_Cap — Thu, 07 Dec 2017 13:31:10 GMT

You can use a tReplace before the tConvert.