topic Re: How to replace null values with numeric value in Talend Studio

How to replace null values with numeric value

Anonymous — Thu, 21 Sep 2017 15:34:06 GMT

Hi,

I'm getting some null values from source column which column having a Number as data type, I want to replace null value with "500" in tMap. I tried with row1.Rate!=null?500:row1.rate but it is throwing the following error.

Error Line: 1119
Detail Message: Type mismatch: cannot convert from Number&Comparable<?> to BigDecimal
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Kindly advise.

Regards,

Re: How to replace null values with numeric value

TRF — Thu, 21 Sep 2017 17:25:53 GMT

Here it is:

row2.rate == null ? new BigDecimal("500") : row2.rate

Hope this helps.

Re: How to replace null values with numeric value

Anonymous — Fri, 22 Sep 2017 10:36:20 GMT

Hi,

Did you compare BigDecimal value with null? If so, 500 is an int, you cannot assign it to a BigDecimal column.

Best regards

Sabrina

Re: How to replace null values with numeric value

Anonymous — Fri, 22 Sep 2017 11:38:39 GMT

it is not giving any error but is not replacing with value.