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.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend