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]

A right, my mistake. You don't need to use a source script, but a onBefore Transform script.

[Anna_Servicenow]

I am sorry, It is still not updating !!

I see the target table is still cmdb table and no update happening in netgear table

[Peter Bodelier]

The target table should not change, because you are using the .ref_cmdb_ci_netgear. to dotwalk to the right table.
It might be that this is not possible this way in a transform map, and only in Business Rule for example.

In that case I would suggest to use @Vishal Birajdar's solution.
 

[Ankur Bawiskar]

@Anna_Servicenow 

So you can use onBefore transform script and determine the class and then set the type

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

	// Add your code here
	if(target.sys_class_name == 'cmdb_ci_netgear')
		target.u_network_type = ''; // give here the correct choice valuef or the target choice field

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

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Anna_Servicenow]

Tried this by removing coleace, It is creating record in ci table, but not updating