How to update a record using Transform Map

[ursnani]

I have to update records on a table using transform map

We have two fields as data types "String" now they want to change it to Decimal type I was unable to Change the data type so they asked to backup the data to excel sheet and transform the data to table again with those old value. 

Can someone please help with me with ON how we can do this. 

[Harsh Vardhan · Accepted solution]

if you are updating a record by using transform map then make sure you need to make field mapping and mark one column as "coalesce " true so this way it will not create duplicate record and do the update on the existing record.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concep...

adding one video link.

https://youtu.be/6TA2Bv85mf4

[ursnani]

I did the same I made a Field coalesce and ran the Transform Map and it worked.

[Harsh Vardhan]

glad it worked.

if your query has resolved mark the answer correct and close this thread .

[ursnani]

Hi Harsha,

Can you please answer for this Question also that would be a great help

https://community.servicenow.com/community?id=community_question&sys_id=a9058cf7db782b0c9d612926ca961965