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 !
Solved! Go to Solution.