How to update data using transform map

[Anna_Servicenow]

I have a requirement where I need to update the network type of different CI classes.

I have a transform map running on cmdb_ci table but I dont find network type in cmdb_ci table but I see it in cmdb_ci_netgear.

How to I use the transform map and update the same?

[Peter Bodelier]

Hi @Anna_Servicenow,

You will need to do this by using a source script.

target.ref_cmdb_ci_netgear.type = 'Your type';

[Anna_Servicenow]

This did not update

error : "Invalid map target does not exist in table cmdb_ci"

[Peter Bodelier]

Please check if 'type' is the right field name. 

[Anna_Servicenow]

yes.. I checked. Attaching screenshots.