replacing null values

[Anonymous]

Hello folks , I am new with Talend and I have faced a problem when I was trying to replace Null values with this string value "cnam".

Before replacing null values contained in the column "CodeMutuelle" , I have to check that the value of the column "MontantCnam" is different than 0.00. 

I have made the following condition in my t_map component : 

row1.MontantCnam != null && ( row1.CodeMutuelle == null) ? "cnam" : row1.CodeMutuelle 

As a result, all null values are replaced by "cnam" , even if the "MontantCnam" is null (0,000) .

PS:   MontantCnam has the BigDecimal data type.

You can find bellow a vue of my data before and after transformation.

Thanks in advance !

[Anonymous · Accepted solution]

0.00 is not null.

You need to use.....

row1.MontantCnam != null && row1.MontantCnam.doubleValue()!=0 && row1.CodeMutuelle == null ? "cnam" : row1.CodeMutuelle