Transform maps

[RaviSankar54]

 Case 1:
I have a incident number and a new incident number, short description and description,  in my excel sheet 
I want to update the existing incident numbers with new incident numbers 
using transform map in service now 


Case 2:
I have only  incident number and a new incident number  in my excel sheet 
I want to update the existing incident numbers with new incident numbers 
using transform map in service now 

[Danish Bhairag2]

Hi @RaviSankar54 ,

U just need to have 1 transform map created for both scenarios as u want to update existing Inc number with new Inc number & other info.

In ur transform map u need to have the field map of existing incident as coalesce so that based upon existing Inc number it will find data n update.

Existing Incident --> Number

For new incident number field map should be like 

New Incident Number --> Number

Short description --> Short description

Description --> Description

Left hand side values will be import set table fields & right hand side values will be Target table(incident) fields

Hope this helps

Thanks,

Danish

[Dr Atul G- LNG]

Hi @RaviSankar54 

It is easily doable, just one thing to note, make the Incident number as coalsec so that it should give error when you try to update. Here is video to understand this.

My friend @Danish Bhairag2 already provided the solution but for future if you need help this video will be helpful

https://youtu.be/urcz82rZW9A