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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.