Five Stars

replacing null values

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 !

 

 

Talend problem.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: replacing null values

0.00 is not null.

 

You need to use.....

 

row1.MontantCnam != null && row1.MontantCnam.doubleValue()!=0 && row1.CodeMutuelle == null ? "cnam" : row1.CodeMutuelle 
Rilhia Solutions
1 REPLY
Twelve Stars

Re: replacing null values

0.00 is not null.

 

You need to use.....

 

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