v26.03: Working with Transform Node
Transform nodes (formerly Calculation nodes) transform data from upstream nodes using various methods.
Available Data Types
| Data Type | Description |
|---|---|
|
v26.03: Mapping |
Transforms data by applying predefined Mapping Tables to input datasets |
|
v26.03: SQL Script |
Provides SQL-based data transformation capabilities |
| Aggregate | Aggregates data based on grouping |
| Append | Appends multiple datasets |
| Deduplicate | Removes duplicate records |
| Filter | Filters data based on conditions |
| Join | Joins multiple input datasets |
| Lookup | Performs lookup operations |
| Pivot | Pivots data structure |
| Python Script | Creates Python-based transformations |
| Recipe | Applies multi-step transformation recipes |
Configure Transform Node
To add and configure a Transform node:
- Select + Add Node. The Add Node dialog opens.
- Select Transform > select the required data type. The node appears on the canvas and the side pane opens.
- Enter the unique Name.
- Configure the node parameters as described below.
- (Optional) In Settings > Precedent Nodes, select nodes that must execute before this node.
-
Select Publish in the Level 2 header to save the configuration.
The system saves the configuration regardless of query validity. After publishing, additional controls become available:
- Refresh: Reloads grid to reflect changes.
- Run: Executes query when valid.
Mapping Node
The Mapping node transforms data by applying predefined Mapping Tables to input datasets.
| Parameter | Description |
|---|---|
| Name | Unique identifier. Defaults to Mapping_[n]. |
| Input | Select an upstream Read or SQL Script node. |
| Steps | Select + Add Step to create mappings. Each step requires Step Name, Mapping Table, and Source Field Mapping. |
| Settings > Precedent Nodes | Select nodes that must execute before this node. |
Mapping nodes support workflow parameter references for dynamic value resolution. Users can reorder, edit, and delete steps via the ellipsis menu. Unmapped Handling inherits the "Fail on Unmapped Source" setting from the selected Mapping Table. The Data Simulation Preview in the central panel displays real-time mapping results.
SQL Script Node
The SQL Script node provides SQL-based data transformation capabilities.
| Parameter | Description |
|---|---|
| Name | Unique identifier. Defaults to SQL Script_[n]. |
| Input | Select + Add to choose upstream nodes. Multiple inputs supported. |
| Query | Enter SQL logic. Select Expand to open Advance View for editing. |
| Settings > Precedent Nodes | Select nodes that must execute before this node. |
- Query Syntax table — showing {{node_name}} and ${dimension_description} with examples
- Supported SQL Operations — SELECT, JOIN, WHERE, GROUP BY, ORDER BY, functions
- Validation info — Select Validate to check syntax before publishing
Note — Nodes can be published with invalid queries (warning icon shows)
v26.02: The query is validated on publish or refresh. The system displays a warning icon when SQL queries access unauthorized components.
v26.04: Query syntax: Use {{node_name}} for input nodes, {{node_name}}.DIM_NAME for dimensions .