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.

combination of three fields make as coalesce in transfer map script?

Arsshad1
Tera Contributor

‎05-03-2024 04:23 AM - edited ‎05-03-2024 04:29 AM

Hi Experts 
Good day!
I have one requirement as below:
In data source transfer map I have 10 fields in those fields the combination of three fields I want to make as unique means coalesce.[ Three field combination same records not to be created/Inserted ] But as my knowledge coalesce "true" I can make for individual  fields. But for this scenario how can I achieve this ?
if it is script like "on after" "on before" Can someone please help me with the script.
Fields are : 1.Customer 2.UCIDN 3.Material ID
staging table : u_material_im

Targer table: u_mat

Any help will be appreciated 

Thanks in advance 
Arsshad

0 Helpfuls
  • 371 Views
1 REPLY 1

Kieran Anson
Kilo Patron

‎05-03-2024 06:14 AM

ServiceNow documentation contains an example for this, called 'Conditional Coalesce'

Updating records using coalesce (servicenow.com)

0 Helpfuls