Transform Map issue

[Debasis Pati]

Hello All,
I have created a transform map for group table created the name field as coelesce and also transformed it it successfully created records everything is fine leaving one thing.
there is a type field which is a list collector in sys_user_group table when i transformed the excel sheet it created some duplicate values in "sys_user_group_type" as incident,change,request etc we already have incident,change,request wtc out of box values how this duplicate value creation can be avoided also it should map the existing correct group types.
one row example of my excel sheet.

Name	Type	Line Vendor/manager	Description	Group email
Test	incident,change	Debasis	test description	test@group.com

@Ankur Bawiskar  any suggestions?


@

[MortenPettersen]

In my PDI i tested and I am able to create another itil type in the sys_user_group_type table, with no error message. So it appears that this table does not care about duplicate names. Unless you think you will create a lot of new types on a regular basis, using the spreadsheet, you could perhaps try to use the Sys IDs to match the type instead of name? I have not tried it myself yet, just a hunch.