How to solve rejected records issues for csv

Eight Stars RAJ
Eight Stars

How to solve rejected records issues for csv

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.

RECORDS REJECTED.jpgTCONVERTTYPE ERROR.png

Thanks
RAJ
Fifteen Stars TRF
Fifteen Stars

Re: How to solve rejected records issues for csv

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.

TRF
Eight Stars RAJ
Eight Stars

Re: How to solve rejected records issues for csv

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

 

Thanks
RAJ
Six Stars

Re: How to solve rejected records issues for csv

You can use a tReplace before the tConvert.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download