duplicate entry when adding group-user in the sys_user_grmember table using transform map script

[shiva_gupta]

I have a source excel file on below format :

Group:   Contain the group name.

User: Contain User Full Name

User ID: Contain user id(unique for each user ex:-A123)

Mapping details are below :

Also user the onAfter transform script as mention below:     -   But if the user is already present in the respective group this transform map is adding the same user twice in the respective group, can anyone please suggest avoiding this duplicate entry.

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

      // get the user

      var usr = new GlideRecord('sys_user');

      usr.get('user_name',source.u_user_id.toString());

      // get the group

      var grp = new GlideRecord('sys_user_group');

      grp.get('name',source.u_group_id.toString());

      // insert group membership and also check wether it is present

      var gr = new GlideRecord('sys_user_grmember');

      gr.addQuery('user', usr.sys_id);

      gr.addQuery('group', grp.sys_id);

      gr.query();

      if (gr.next()){

      //no action required

      }

    else {

    var grMember = new GlideRecord('sys_user_grmember');

      grMember.initialize();

      grMember.user = usr.sys_id;

      grMember.group = grp.sys_id;

      grMember.insert();      

      }

    })(source, map, log, target);

[shiva_gupta]

Yes, you are correct it can be easily done without the script. Actually, I came across a situation where two different instances are acting differently on mapping the user_id and group_id with the same input data so, I am testing whether the situation is same or different with the run script action.