ServiceNow Transform Maps: check if all rows in the import staging table match the target rows

//--t-map on complete script

accountTableTrueUp(import_set.number);

//accountTableTrueUp('ISET0011535');

function accountTableTrueUp (import_set_number) {

var flat_file_arr = [];

var grST = new GlideRecord('x_cls_clear_skye_i_eon_hr_import');//--the staging table name of the transform

grST.addEncodedQuery('sys_import_set.number=' + import_set_number);

grST.query();

while (grST.next()) {

//gs.print('employee number:' + grST.u_employeenumber);

//flat_file_arr.push(grST.sys_target_sys_id+'');

flat_file_arr.push(grST.u_employeenumber+'');

}

gs.print('flat_file_arr='+flat_file_arr.toString());

var arrStr=flat_file_arr.toString();

var grAC = new GlideRecord('x_cls_clear_skye_i_account');

grAC.addEncodedQuery('account_type=5bd21b7b97db2550df843a300153af71^status=1');

grAC.query();

while (grAC.next()) {

var emplNum=grAC.getValue('employee_number');

var bMatch=flat_file_arr.indexOf(emplNum, 0)>-1;

gs.print('ARRCHK:' + flat_file_arr.indexOf(emplNum, 0));

if (bMatch) {

gs.print(grAC.employee_number + ' good to remain');

} else {

gs.print(grAC.employee_number + ' flagged for removal');

}

}

}