Using Variables

Besides data tables, variables are another fundamental type of object used for calculations and control flow in Megaladata Studio.

A variable is a named value belonging to one of the available data types.

Dedicated variables ports are used to receive and transfer variables between nodes. This type of port can handle multiple variables simultaneously, both as inputs and outputs.

This way, a list of variables can be transferred from node to node.

Examples of using variables:

• Employing a variable in a formula for calculating an expression value within a Calculator node.
• Using a variable as a parameter of the Condition component.

Control variables

Variables can also be used dynamically to configure node settings during workflow execution. These are often called control variables.

This allows node parameters themselves to be calculated or determined by the preceding workflow logic, enabling more flexible and adaptive data processing logic.

Here are some practical examples of employing control variables:

• Using a variable to define filtering criteria in the Row Filter (e.g., setting the filter condition based on a calculated variable).
• Using a variable that holds the complete SQL query string to be executed by a Database import node.

Read on: Interface