Seven 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

3 REPLIES
Twelve Stars TRF
Twelve 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
Seven Stars

Re: How to solve rejected records issues for csv

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

 

Six Stars

Re: How to solve rejected records issues for csv

You can use a tReplace before the tConvert.