topic Re: NumberFormat Exception in Talend Studio

NumberFormat Exception

talendstar — Sat, 16 Nov 2024 04:13:10 GMT

I am loading a csv into Snowflake and using tMap. I am getting following error (even though data is loaded and I dont have any NULLs for the column in question):

Couldn't parse value for column 'Prob' in 'row1', value is 'Prob'. Details: java.lang.NumberFormatException: For input string: "Prob"
[ERROR]: talend71.load_level_info_0_1.Load_Level_Info - tFileInputDelimited_1 - Couldn't parse value for column 'Prob' in 'row1', value is 'Prob'. Details: java.lang.NumberFormatException: For input string: "Prob"

Here is what my tmap looks like:

rowschema editor

The source data in .csv looks like this:

0.2368809416209197

in destination it looks like this:

0.24

so I am not sure where the error is coming from.

thoughts?

thanks

Re: NumberFormat Exception

TRF — Wed, 30 Oct 2019 16:35:35 GMT

The error is from tFileInputDelimited, not tMap nor Snowflake itself.
The reason is you have the value "Prob" in that field or this is the field label and you just have omitted to set the header line to 1 into tFileInputDelimited settings.

Re: NumberFormat Exception

talendstar — Wed, 30 Oct 2019 16:58:46 GMT

that was it. you are a champ!!!

thanks

Re: NumberFormat Exception

TRF — Wed, 30 Oct 2019 18:08:04 GMT

You're welcome