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
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.