Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

What is the purpose of Empty Coalesce Field in Transform map?

Community Alums
Not applicable

Can someone please help me in understanding the use of this field. Where and why will this field will be used?

6 REPLIES 6

ArunavaS
Tera Contributor

you check coalesce empty, then for target empty field it will update the record in source table instead of creating a new record. Though it is not used very frequently. 

Community Alums
Not applicable

When the Coalesce field is empty - Every incoming record is treated as a new record. No attempt is made to match and update existing records.