by tmap job replace"null" per 0 as BigDecimal

[Anonymous]

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

[TRF]

In your tMap, try this to replace null values by 0:

row1.AgencyNetwork == null ? new BigDecimal(0) : row1.AgencyNetwork

[Anonymous]

thx a lot. now is running 🙂

[TRF]

Great!

Thank's to mark your case as solved (Kudos also accepted).

[abhi90 · Accepted solution]

Hi @nero0x0,

Please mark the answer of @TRF as accept as solution so that others can use it later

[TRF]

@nero0x0, it seems you know how to open a case, but not how to close it!!!!

@abhi90 is probably happy of that

[hangel]

 @TRF - Good Day ! Need help on my new column addition from tsalesforce input .

How to convert BIGDECIMAL in to String using tmap component and also i have to pass '$' along as prefix. Used the below sample expression. Certain records are getting updated , however huge records failed to update. Getting Null poin exception error. Please help, Thanks !

Sample Expression --> "$"+out1.Net_Revenue__c == null ? "null" : "$"+out1.Net_Revenue__c.replace("-","")

[TRF]

Read the answer in this thread or open a new case