SOLVED

Duplicate records in Org Data File

Silver Contributor

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 Reply
best response confirmed by Sanjanaa_Ellur (Microsoft)
Solution

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.