Forum Discussion
VI_Migration
Sep 21, 2021Silver Contributor
Duplicate records in Org Data File
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?
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.
1 Reply
- VI_MigrationSilver Contributor
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.