Forum Discussion

VI_Migration's avatar
VI_Migration
Silver Contributor
Sep 21, 2021
Solved

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_Migration's avatar
    VI_Migration
    Silver 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.

Resources