While trying and loading the data in output database, i am getting below error:
Couldn't parse value for column 'CID' in 'row1', value is '"5"'. Details: java.lang.NumberFormatException: For input string: ""5""
Couldn't parse value for column 'CID' in 'row1', value is '"48"'. Details: java.lang.NumberFormatException: For input string: ""48""
PFA screenshots of tMap
Please suggest the needful
The error "NumberFormatException: For input string:" usually occurs when Talend identifies inserting string value in the integer field. So make sure that if you are inserting the value form CSV file in to the field having data type as integer, it should not consist of string/character value or you can map the input column of CSV file to the field having data type as string.
@anurag13_,i suggest you to convert sting to integer,if required apply replaceall function for " with space.
Take a look at the this thread https://community.talend.com/t5/Design-and-Development/java-lang-NumberFormatException-error/td-p/81... or refer to https://domyhomeworkonline.net/ please.
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.