v26.01: Working with Write Nodes

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

Note: 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.

Note: 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.

v26.04: Configuring Master Data ode

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

To configure a Master Data node:

Click + Add Node from the Level 2 header. The Add Node dialog opens.
Select Write from the left panel.
Select Master Data from the right panel. The node appears on the canvas and the configuration side panel opens.

Fill in the required fields from the configuration panel:

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.
v26.05: Settings (Optional)	Configure Precedent and Subsequent nodes to control node execution order. See Working with Node Settings for more details.

Select Publish in the Level 2 header to save the configuration.

Note: The Master Data node supports insert and update operations, automated data synchronization, and dimension member management.

Configuring Sheet Node

Sheet nodes save processed data to sheets within the workspace.

To configure a Sheet node:

Click + Add Node from the Level 2 header. The Add Node dialog opens.
Select Write from the left panel.
Select Sheet from the right panel. The node appears on the canvas and the configuration side panel opens.