Transform script to check the source record exist in target table

[Sangeetha8]

Hi All,

I had a requirement to check the source field(caller)incident table is exist in the target field(approver)user table (sys_user) if the record is exist then map that field,else keep the target field as empty 

How to achieve this using tranform script in field mapping

Thanks

[PrashantLearnIT]

Hi @Sangeetha8 

You can make the field mapping coalesce as true, it will work same way how you have to do.

For More Details Refer this link - https://docs.servicenow.com/bundle/vancouver-integrate-applications/page/administer/import-sets/conc...

[Dr Atul G- LNG]

Hi @Sangeetha8 

You can use coalsec but I am interested to know what is exact use case. 

https://youtu.be/6dU9yBQPq_I

[Sangeetha8]

Hi @Dr Atul G- LNG 

My issue is that once integration is happened there is a empty record gets created in the sys_user table if there is no matching found in field mapping.

How to rectify this issue

Can I write a source script?

[Robbie]

Hi @Sangeetha8,

This is very easily skipped by the use of an 'onBefore' 'Transform Script'.

See the below screenshot to help visualize and use the following code within the Source Script. (Obviously, check against the appropriate field for your needs. Here I am using the email address)

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

if(source.u_email == target.email || source.u_email == target.user_name){

ignore = true;

}

})(source, map, log, target);

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie