Seven Stars

Catch error with file column details

Hi,

I have a colum in a delimited file which is defined as BigDecimal in the file Metadata however the actual record has the data in the form of String.

Talend Job is throwing an error as unable to parse a string in BigDecimal which is correct.

 

Now i have other multiple columns defined as BigDecimal in the same file.

From the error i can identidy the row number but how can i identify the specific column which has issue ?

I used log catcher and stat catcher but i couldnt find any relevant détails about the specific column.

Pls suggest on how can i get the erroneous column.

 

Sample text file

A(String)| B(BigDecimal)| C(BigDecimal)

A1245| 1245| 451RE

 

Here the column C has error value

 

Thanks

2 REPLIES
Six Stars

Re: Catch error with file column details

I think I would loop the columns in a tJava and detect the faulty column with a try-catch

Seven Stars

Re: Catch error with file column details

I found the tScehmaComplaince component to check all the data with schema defined however the rejection wont give me the row numbers or row information, dont want to go for code for this ...