Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Transform Map Script

aagman4
Tera Contributor
Control table extends table - Control/Risk. Transform map is on Control/Risk table. I wanted to update custom fields u_key_entity and u_key_system present in Control table. I am using below code in Transform Script but it is being ignored with error - Invalid map target u_key_system does not exist in table sn_compliance_control
 
if (source.u_class == 'Control') {
        var controlInfo = new GlideRecord('sn_compliance_control');
        controlInfo.addQuery('number', source.u_number);
        controlInfo.query();
        if (controlInfo.next()) {
            controlInfo.u_key_entity = source.u_internal;
            controlInfo.u_key_system = source.u_other;
        }
    }
 
Let me know if I am missing anything here.
 
Thanks in advance!
0 REPLIES 0