HI, i need a little help.....after to my TMAp job, some fields are "default". That is also correct according to mapping. Zero means empty. However, I want to write a variable that says if zero then replace the field with a number0. I tried Replace but it can only replace string and not big decimal. Is there a solution for this? Many thanks
Solved! Go to Solution.
In your tMap, try this to replace null values by 0:
row1.AgencyNetwork == null ? new BigDecimal(0) : row1.AgencyNetwork
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.