What is a calculated field?
A calculated field is a column that does not exist in your HRIS but is derived from other fields in your dataset. It exists in Aragorn AI only—it is not written back to your HRIS.
Example: Your HRIS has separate first_name and last_name columns, but a vendor needs a single full_name. A calculated field concatenates them. Or your HRIS has marital_status (M, S, U) and you need is_married (true/false).
When to use calculated fields
Derive boolean flags from coded values
Strip formatting from fields (for example, hyphens from SSN)
Create columns your HRIS does not support natively
Create a calculated field
1. Open source mapping
Log in to your Aragorn AI account.
Open Data Projects and select your project.
Go to the source mapping configuration.
2. Add a calculated field (FX)
Click the FX (calculated field) action.
Name the new field (for example,
is_married) all in lowercase.Choose the output data type (for example, boolean).
3. Define the logic
Aragorn AI offers two approaches:
Prewritten logic templates — common calculations (for example, combining name fields). Select a template and choose the source fields to use.
Custom code from scratch — write JavaScript logic or use the AI assistant to generate it from a natural-language prompt.
Example prompt:
If marital_status is M return true, else return false.
Click Run logic test to verify sample inputs and outputs before saving.
4. Add description and validations
Add a description so Aragorn AI understands the field’s business meaning.
Configure whether missing values are allowed.
Indicate if the field can be used for filtering in integrations.
5. Standardize the calculated field
A calculated field is treated like any other source column—you must map it to a standardized field (for example, is_married). To edit or delete later, use the mapping utility panel.
6. Save and apply
Save the calculated field.
Run Reprocess last sync or Sync new updates so values populate in the final dataset.
Verify results
Open the project final dataset.
Confirm the new column appears with expected values.
Use lineage to see which source fields feed the calculation.