Need help in Transform Script

[Admin7267]

I'm new to CMDB data loading, I was working on data load using excel. 

I see there are few reference fields in excel[Assigned to, Company], but instead of sys_id, the display value of the names are given. 

How to convert those update those Assigned to and Company fields? 

[Danish Bhairag2]

Hi @Admin7267 ,

You can refer below link where u can achieve this requirement with no scripting

https://www.servicenow.com/community/developer-forum/populate-reference-field-using-transform-map-sc...

Thanks,

Danish

[Abhijeet_Pawar]

Hello @Admin7267 ,

use Below script which will resolve your query.

use onbefore event script
   
    var assignedTo = new GlideRecord('sys_user');
    assignedTo.addQuery('name', source.u_assigned_to); 
    assignedTo.query();
    if (assignedTo.next()) {
        target.u_assigned_to = assignedTo.sys_id; 
    }

    // Get the sys_id for the "Company" field
    var company = new GlideRecord('core_company');
    company.addQuery('name', source.u_company); 
    company.query();
    if (company.next()) {
        target.u_company = company.sys_id; 
    }

If my response helps you resolve your issue. Kindly mark it as helpful & correct. It will be helpful to future readers! 

Thanks and Regards,
Abhijeet Pawar.

[Anand Kumar P]

Hi @Admin7267 ,

Refer below link
https://www.servicenow.com/community/developer-forum/transform-script-for-reference-field/m-p/207635...

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand