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 

then did you check the actual name in that table has spaces in ending

If the name is exact then it should match and should not show 0 records

💡 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 ,
Yes i checked it seems the actual values does contain space.

[Ankur Bawiskar]

@Debasis Pati 

how about exact match for each of those values without leading or trailing spaces

Name = incident

OR

Name = request

OR

Name = problem

OR

Name = change

Any query business rule on "sys_user_group_type" is restricting the query

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

[Debasis Pati]

@Ankur Bawiskar ,
I said the values i checked it does contain spaces also i checked there are no business rules on that table.

[Ankur Bawiskar]

@Debasis Pati 

I think you didn't apply any such filter till now, please use that and share results

It's definitely something to do with the data

are you using the updated transform script?

are you getting the individual values correctly while iterating in for loop?