Transform map group data

[Yasin Shaik11]

Hi,

I got one assignment i.e

 1.Customize ‘Group’(sys_user_group) Form by adding a new field called ‘Parent Group’ and reference this field to Groups table (sys_user_group)

2.Export all the existing groups from sys_user_group table into CSV file.

3.Update the CSV file ‘Parent Group’ field with any random existing group

4.Upload the updated CSV file into sys_user_group , and map ONLY newly updated ‘Parent Group’ field using Transformation Map

I've completed the above 1 to 3 steps and coming 4th step i've made the Coalesce true  for that field after click on the transform in the history i am getting error nothing...

Thanks in advance 

[Anil Lande]

Hi,

Please make Name field as  Coalesce TRUE.

Thanks,
Anil Lande

[Anshu_Anand_]

use coalesce as group name. Since a group name with duplicate name is an exceptional case and also minimum chances there will be any duplicate names.

In csv, use two fields-  group name, parent group

group name as coalesce.

when imported into servicenow, in transform map, for parent group field use reference name as name

Try it , if works

Mark answer as correct