Icon

Data Aggregator Tool

<p><strong>Tool Description</strong></p><p><br>This tool performs <strong>flexible data aggregation</strong> on customer-related datasets.<br>It takes user-defined inputs (groupby columns, measure, and aggregation function) and produces aggregated customer data in JSON format for downstream use by an AI agent.</p><p>The <strong>Data Source</strong> parameter controls whether the aggregation is performed on the <strong>cached customer data</strong> (from a previous lookup) or on the <strong>full dataset</strong>. This enables more efficient workflows, where the agent can either focus on a single matched customer or compute aggregations across all available records.</p><p><strong>Input Parameters</strong></p><ul><li><p><strong>Groupby Columns</strong><br>A list of categorical columns used to define the grouping level for the aggregation.<br><em>Example:</em> ["Customer","Year"]</p></li><li><p><strong>Measure</strong><br>A numeric column to aggregate.<br><em>Example:</em> "Sales"</p></li><li><p><strong>Aggregation Function</strong><br>A function specifying the operation to apply to the measure.<br>Supported: <strong>Sum, Mean, Min, Max, Count, Median</strong></p></li><li><p><strong>Data Source</strong><br>Determines whether to use the <strong>cached customer data</strong> (subset of records) or the <strong>original dataset</strong> (all records).</p></li></ul>

URL: exorbyte GmbH https://www.exorbyte.com/en

Aggregation Function
String Configuration
CASE Switch Start
Measure
String Configuration
Cached Customer Data
Table Reader
Groupby Columns
Multiple Selection Configuration
Column Appender
Filter the groupby columns
Column Filter
List of String Columns
GroupBy
Column Name Replacer
Data Source
Table Reader
Filter the measure columns
Column Filter
Table Row to Variable
CASE Switch End
GroupBy
Data source
Single Selection Configuration
Merge Variables
Customer Data
Table to JSON
Tool output
Tool Message Output

Nodes

Extensions

Links