Duplicate department records

[Vadla Srimaan]

Hello!

Need inputs on handling a data inconsistency scenario.

In our department table, few departments manually added via XML and users got assigned to them.

Again, from workday integration same departments data was created and some other users were assigned to them.

Now on SP portal, record producer forms have department question and users are seeing duplicate records and confused with what to select.

Now how to delete duplicate records?

Please guide me if you have fixed similar issue.

[Sandeep Rajput]

@Vadla Srimaan You can check History on record and see which record was created by import and which one came through Workday integration. Choose the one you want to keep, map the users and delete the other.