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?


@

[Debasis Pati]

so what i did now i copied the values of incident,chang,problem& request i found there is an extra space after all of them and i applied the same and found the 4 records.

[Debasis Pati]

Also @Ankur Bawiskar ,
When i used starts with query it is fetching the exact sysids and everything works fine but using startswith will not be a feasible query for future.

[Ankur Bawiskar]

@Debasis Pati 

I am saying try with exact match as that will help you in transform script.

what are the results when you use this?

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

[Ankur Bawiskar]

@Debasis Pati 

Hope you are doing good.

Did my reply answer your question?

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

[Bhuvan]

@Debasis Pati 

It could be due to below limitation explained in knowledge article, check the behavior in Sub-Production instance and proceed accordingly

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0760528

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan