Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
that was it. you are a champ!!!
thanks