NumberFormat Exception

[talendstar]

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

[TRF · Accepted solution]

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.

[talendstar]

that was it. you are a champ!!!

thanks

[TRF]

You're welcome