java.lang.NumberFormatException: null error

[Anonymous]

I'm on version 7.1.1 I am passing data into Salesforce (Output)

I'm getting another error i can't figure out what's going on in the tmap: 

Error: 

java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)

I've taken a screen shot of the mapping....most are string to string.... it's just one column where both the input and output are type BigDecimal that is the only one I can think of that might have an issue with NumberFormatException? "0".equals(row16.YR_HSLD_INCOME)? null : row16.YR_HSLD_INCOME  I added the "0".equals just in case that would fix it but it didn't. (I don't think I really need that).

Thanks! 

[Anonymous]

Hi,

    I believe you are trying to do a string processing function to a numeric value. Could you please try below snippet and let us know the results?

row16.YR_HSLD_INCOME==0?null:row16.YR_HSLD_INCOME

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

It's actually a BigDecimal to a Big Decimal and when i tried your solution i got a pop up error instead

[Anonymous]

Ok.. Lets try BigDecimal function then.

(row2.data.compareTo(BigDecimal.ZERO)== 0)?null:row2.data 

Please try like above and let us know your results.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

so strange, i tried your BigDecimal version and still getting the Null error! All other Output columns are mostly string to string and one date to date. Any other ideas? I'm completely stuck. Thanks!