Importing the data in the reference field fails when using direct field mappingIssue Selecting the option of use source script provides flexibility to apply complex logic to query the data from the reference table.ResolutionInstead of using direct field mapping, customers can use the option of use source script. In the source script, a script similar to the following can be used - answer = (function transformEntry(source) {// Add your code herevar gr = new GlideRecord('sys_user_group');gr.addQuery('name',source.<source_field>);gr.query();if(gr.next())return gr.sys_id; // return the value to be put into the target field})(source); In the script, customer can apply their own logic to query data against multiple columns. Using script also provides more flexibility to apply complex business logic to query data and return the exact record which needs to be referred.