What is the latest record rule?
Some supplementary projects contain multiple rows per employee—for example, attendance or shift data with one row per day.
The latest record rule groups records by an identifier (such as employee_id), sorts by a date field, and keeps the most recent row per group for enrichment.
Example: A shifts project has three rows for one employee (Monday, Tuesday, Wednesday). Latest record rule groups by employee_id, sorts by work date descending, and keeps only Wednesday’s row when enriching the employee profile.
When to use it
Supplementary data is event-based (shifts, payments, status changes over time).
Integrations need “current” or “most recent” values from a history table.
You must collapse many rows into one lookup row per employee.
Configure latest record rule
Log in to your Aragorn AI account.
Open the main project and create or edit an enrichment linked to a supplementary project with multiple rows per person.
In enrichment advanced settings, enable latest record rule.
Set group by — typically
employee_idorexternal_employee_id.Set sort by — a date or timestamp field (for example,
start_date,hired_date, or shift date).Choose most recent first so the newest record per group is kept.
Preview results to confirm one record per employee with the expected date.
Save, map output fields, and reprocess the main project.
Screenshot: Latest record rule configuration—group by employee_id, sort by date, most recent first.
Screenshot: Preview showing one record per employee after latest record rule is applied.