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.
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
View this on-demand webinar about APIs....