Transform Map help !!

[vidishaagarwal5]

In a ServiceNow Transform Map, how can you restrict the insertion of new records and allow only updates to existing records during data import?

[Ravi Gaurav · Accepted solution]

Hi @vidishaagarwal5 

In transform map main script, we can check for operation by using 'action' variable and set 'ignore' variable as true/false based on the value as shown in below script :

if(action=='insert'){
ignore=true;
}

[Ravi Gaurav · Accepted solution]

Below Will help you to understand Transform Map !!

https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/script/server-scripting/co...

[Ravi Gaurav · Accepted solution]

Hi @vidishaagarwal5 

In transform map main script, we can check for operation by using 'action' variable and set 'ignore' variable as true/false based on the value as shown in below script :

if(action=='insert'){
ignore=true;
}

[Ravi Gaurav · Accepted solution]

Below Will help you to understand Transform Map !!

https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/script/server-scripting/co...

[Dr Atul G- LNG · Accepted solution]

Hi @vidishaagarwal5 

use the coalesce. 

Coalesce is commonly used with Transform maps in ServiceNow. It is used to set a field as unique, so that when data is imported :

- If ServiceNow identifies the data against an existing record using Coalesce, then it will update that record.

- If ServiceNow identifies the data against no existing records, it creates a new one.

So lets take this as a simple example, we want to load the below User information through Transform Maps into our User table. We set Employee ID as the Coalesce field

Here is the data we are loading in. 

Employee ID	Name	Country	Role
001	John	Ireland	Sales
002	Sarah	England	IT
003	Amy	Scotland	HR
004	Brad	America	Marketing

Here is the data that exists in the User table already

Employee ID	Name	Country	Role
001	John		Sales
002	Sarah	England
003		Scotland	HR

Here is what the table would look like after the transform map runs

Employee ID	Name	Country	Role
001	John	Ireland	Sales
002	Sarah	England	IT
003	Amy	Scotland	HR
004	Brad	America	Marketing

https://youtu.be/vKIQ1IZDP10

[vidishaagarwal5]

Thanks @Ravi Gaurav  the code worked for me.. thanks @Dr Atul G- LNG  it helped me understand more in depth. your videos are good