cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records in Org Data File

Pranathi_K
New Contributor II
New Contributor II

How does Workplace Analytics process duplicate employee records in the organizational data? For example, two records that have the same PersonId and EffectiveDate, but different values in the other columns? Which record will be applied?

1 ACCEPTED SOLUTION

Peter_Baker
Moderator
Moderator

If there are duplicated records in the same upload, Workplace Analytics will randomly pick one to process. When the duplicate happens across multiple uploads, the record in most recent upload will be applied.

View solution in original post

1 REPLY 1

Peter_Baker
Moderator
Moderator

If there are duplicated records in the same upload, Workplace Analytics will randomly pick one to process. When the duplicate happens across multiple uploads, the record in most recent upload will be applied.