AI Finance Tool icon

AI Finance Tool

Controlled allowlist facade for AI Agents to call finance/data/predictive tools safely.

Actions10

Data → Normalize Data

AI-generated

Summary

Normalize input financial or tabular data by cleaning and standardizing its values using optional advanced settings and currency metadata, limiting processing to a configurable maximum number of rows.

Inputs

  • Advanced Domain Options JSON — A JSON object containing advanced domain-specific options passed to the normalization operation without evaluation of formulas or code.
  • Currency — An optional string to indicate the currency context for normalization relevant to finance operations.
  • Max Rows — A number that sets the hard maximum limit on input data rows processed by this operation, defaulting to 1000.

Output shape

A normalized dataset reflecting cleaned and standardized values with imposed row limits.

The normalization respects advanced options and currency metadata but does not evaluate formulas within passed JSON options. Processing is capped by the Max Rows parameter to prevent excessive input size.

Examples

Example 1: You have diverse financial transaction data containing inconsistent date formats, numeric strings, and currency entries. Using Normalize Data with a specified currency and default max rows, the operation standardizes these fields for easier downstream analytics.

Set 'Currency' if the data involves a specific currency to guide normalization. Optionally provide JSON in 'Advanced Domain Options JSON' for additional control. Leave 'Max Rows' at default unless limiting input size is needed.

Links

Discussion