2 coalesce field on a transform map not working properly

[Evren Yamin]

Hello,

I have a transform map that needs to have 2 coalesce field but it is not working. It just inserts instead of updating the record. Does having 2 coalesce work?

Appreciate all the help

[-O-]

Are the amount fields the currency type? If so, it may be that that is why it is not working. And in that case you will most likely need to resort to script based coalesce for target field sys_id.

[Evren Yamin]

Yes, the amount filed is in currency type. Sure will try using script based coalesce

[Community Alums]

You might want to use scripted coalesce for this requirement. You can use "getCurrencyValue()" to get the value as entered in unformatted number format.

BR, Gaurav

[Community Alums]

You can check other methods below - 

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/currency/concept/currency-values-scripts.html#:~:text=Methods%20to%20access%20currency%20fields

[Evren Yamin]

Thank you, I will try this out