Add Roles to Groups from Transform Map

[Robbie Lacivita]

I am attempting to write an onAfter Transform Script to assign roles to groups based on values from the loaded spreadsheet. The transform map would create the groups, then the script would run to determine which roles go in each group based on whether or not the role is specified in the spreadsheet.

Is this possible, and if so how would it be scripted? I cannot find how to check a cell in the spreadsheet for a value to then assign a role to the newly created group.

Thanks,

Robbie

[Alberto Consonn]

Hi,

check and use the script provided in the thread below:

https://community.servicenow.com/community?id=community_question&sys_id=2fe153eddbdcdbc01dcaf3231f96...

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Robbie Lacivita]

Alberto,

Thank you for the response. I solved this by using two transform maps on the table. The first map creates the groups, the second one assigns the roles to the newly created groups. No scripting needed at that point.

Thanks,

Robbie

[Alberto Consonn]

Good to know, could you please close the thread?

Thanks
Alberto