topic Re: Catch error with file column details in Talend Studio

Catch error with file column details

vidya821 — Wed, 20 Jun 2018 15:03:32 GMT

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

Re: Catch error with file column details

navds — Thu, 21 Jun 2018 10:31:10 GMT

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

Re: Catch error with file column details

vidya821 — Thu, 21 Jun 2018 13:16:37 GMT

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 ...