How to update a field value using transform maps

[Pranavi07]

Hello,

we have the Jamf integration setup thorough service graph connector and with this a default robust transformer was created instead of transform maps. our requirement is to update a company field on cmdb_ci table with a default value "company xyz" for all the devices created with this integration. How do we do this?

[Saiganeshraja]

For already loaded data " Run - Fix script to update the company field". For future data write after script in the transform map. 

Mark correct and helpful.

[Pranavi07]

Hello @Saiganeshraja ,

Thanks for replying but the problem here is we don't have a transform map, all we have is an OOB robust transformer and there is no after script like we have in transform maps, there are many targets and sources and we are not sure what to do here. 

[Pavankumar_1]

Hi @Pranavi07 ,

Once you are done with RTE entity mapping then you can do the RTE field mapping.

[Pavankumar_1 · Accepted solution]

Hi @Pranavi07 ,

you can create a temp company variable on importset table and using Robust Transform Engine Entity Operations you can set that and populate on target table.