replacing null values

Anonymous — Wed, 07 Jun 2017 09:56:30 GMT

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 !

Re: replacing null values

Anonymous — Wed, 07 Jun 2017 10:01:27 GMT

0.00 is not null.

You need to use.....

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

topic replacing null values in Talend Studio

replacing null values

Re: replacing null values