Same User name is creating issue while transforming the data into User allocation table

[shivani42]

Hi All,

We are having an issue while transforming the data into user allocation table. In Servicenow's user table, we have multiple user where the user name is same for more than one user but in general they are different user because they have different employee code. Now, when i tried to transform the data into user allocation, there is a business rule"Prevent duplicate allocations" is causing the issue. I am not able to understand how can i use employee code while comparing the data.

You can see in attached excel file. These are the fields which i am trying to update.

My transform map - 

I was thinking to use source script but again this is first time i am doing this. Any suggestion would be very helpful!

Thanks,

Shivani

[KeerthiP]

Hi,

I can suggest you two options if option 1 doesnt work then 2

1)For the employee_code field, set Coalesce as true

2) Modify the "Prevent duplicate allocations" business rule to include a check for both user_name and employee_code to prevent duplicate entries.

Thanks,

Keerthi