Hello,
You can use below script in transform map script to update target record:
var gr = new GlideRecord(target.getTableName());
gr.addQuery("sys_id", source.getValue("FIELD_NAME_HOLDING_SYS_ID_IN_SOURCE_TABLE"));
gr.query();
if(gr.next()){
//update fields here as per your requirement
gr.FIELD_NAME = source.FIELD_NAME;
gr.update();
}else{
ignore = true;
}
But I am wondering why you do not want to user field map and go for script. unless you need to manipulate/format data and then copy to target field, it is recommended to use field map as it is easiest way to configure transform map.
Thank you,
Ali
If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!
Thank you,
Ali
