v26.01: Working with Write Node

Write nodes save processed data from upstream nodes to target destinations, completing the data processing pipeline. Write nodes function as terminal nodes in workflows, meaning they only accept input connections and cannot provide output to subsequent nodes.

Available Write Node Types

Data Type	Description
Sheet	Writes data to sheets including standard sheets and multi-section sheets
v26.04: Master Data	Writes to master data entities such as hierarchies and reference data
Table	Writes data to tables within the system
Remote Table	Writes data to remote tables in external systems
Journal	Writes journal entries for transactional data

Configure Write Node

To add and configure a Write node:

Select + Add Node. The Add Node dialog opens.
Select Write > select the required data type. The node appears on the canvas and the side pane opens.
Enter the Unique name.
Select the Target using the inline selector.
Configure the Layout Definition and Field Mapping.
Select the Write Mode (Overwrite, Merge, or Append).
(Optional) Select Test to validate configuration without committing changes, or Preview to view the data frame that will be written.
Select Publish to save the configuration.

The system validates metric uniqueness across all Write nodes in the workflow. Preview write data in the Execution Output section.

Write nodes only accept input connections and cannot provide output connections to other nodes. They function as terminal nodes, marking the end of data flow paths in the workflow.

Configuration Layout

Write nodes require comprehensive configuration to define output destination, data structure, source mapping, and write behavior.

Layout Definition

The Layout Definition specifies the output data structure with specific requirements for each section.

Section	Allowed Elements	Member Selection	Purpose
Rows	Dimensions or Metrics	Dynamic or Fixed	Elements that appear as rows in the output structure.
Columns	Dimensions or Metrics	Fixed leaf members only (multi-select enabled)	Elements that appear as columns in the output structure. Relationship must be "Current Member".
Filters	Dimensions only	Fixed leaf members only	Defines the fixed intersection for data posting without displaying in output.

Metric selection is mandatory regardless of where metrics appear in the layout structure (Rows, Columns, or Filters). Each metric can only be used in one Write node across the entire workflow. The system validates metric uniqueness and displays an error if duplicates are detected.

Field Mapping

The Field Mapping section establishes correspondence between input data and output structure. The interface displays a two-column view with Source Fields from the input node on the left and Target Fields from the output layout on the right.

Mapping Requirements:

All target fields must be mapped to source fields.
Source and target data types must be compatible.
The system prevents incompatible mappings (string to number, date to string, etc.).
When source has more columns than target: System aggregates data automatically.
When target has more columns than source: User must modify layout to move extra dimensions to filters.
For sheet targets: Source columns must be unique (no duplicate records requiring aggregation of non-numeric fields).

Write Mode Options

Write Mode determines how the system handles existing data in the target destination.

Write Mode	Behavior	Use Case
Overwrite	Clears existing data based on specified criteria before writing new data. Requires configuration of clear header to specify which data to clear.	Full refresh of data where previous values should be replaced.
Merge	Updates existing records where dimension combinations match exactly. Inserts new records where no match exists. Functions identically to file upload merge behavior.	Incremental updates where some records are updated and new records are added.
Append	Adds records without clearing existing data. Primarily applicable for table targets (queue-based operations). Not relevant for sheet targets.	Adding new records to existing data without modifications.

Overwrite Mode Configuration

When Overwrite mode is selected, configure the clear header to specify what data to clear:

Option	Description
Fixed Member	Clears data for a specific member only.
Source Data	Uses values from input data to determine what to clear.
Context Variable	Uses workflow context values to determine what to clear.

Sheet Write Node

Sheet Write nodes save processed data to sheets within the workspace.

Parameter	Description
Name	Unique identifier. Defaults to Sheet write.
Target	Select a sheet using the inline selector ("Click to Select").
Layout	Configure Rows, Columns, and Filters sections.
Input	Select an upstream node (Read or Transform) using the inline selector.
Mapping List	Map target fields to source fields.
Write Option	Select Overwrite, Merge, or Append. Determines how the system handles existing data in the target.
Set Overwrite based on	For Overwrite mode, configure: Fixed Member, Source Data, or Context Variable.
Settings > Precedent Nodes	Select nodes that must execute before this node.
Settings > Subsequent Nodes	Displays nodes that execute after this node (read-only).

Sheet Write is currently the only enabled Write data type for production use. Metric selection is mandatory in the layout structure. Each metric can only be used in one Write node across the entire workflow.

v26.04: Master Data Write Node

The Master Data Write node writes data directly to master data tables within the workspace.

Parameter	Description
Name	Unique identifier. Defaults to Master Data_[n].
Target	Select a master data table using the inline selector ("Click to Select").
Input	Select an upstream node (Read or Transform) using the inline selector.
Mapping List	Map source columns to target table columns.
Settings > Precedent Nodes	Select nodes that must execute before this node.
Settings > Subsequent Nodes	Displays nodes that execute after this node (read-only).

The Master Data Write node supports insert and update operations. This node supports automated data synchronization and dimension member management.