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?


@

[Ankur Bawiskar]

@Debasis Pati 

type field on group is list type and can hold 1 or more 1 sysIds

So did you give Reference value field name in the field map so that it searches the exact name

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Debasis Pati]

Hello @Ankur Bawiskar ,
The below is my mapping assist

anything else i need to take care of

[Ankur Bawiskar]

@Debasis Pati 

I already shared screenshot above on what you need to fix and check

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Debasis Pati]

Hello @Ankur Bawiskar ,
I tried your suggestion but it still created duplicate types