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