Icon

01 - Simple Variables

Variables are available in all connected DOWNSTREAM nodes

Data Merging merges Variables as well!

IMPORTANT:

Watch the naming, as equal variables names will be overwritten!

How to create Variables

Variable Creator

Using "Flow Variables tab" from every node

Conversion of table entries

How to work with Variables

Widget Nodes - convinient for data apps

Why Variables

Example: Read some data and filter for a, do some math, store into Excel Sheet a

Table Creator
Filter uses Variable
Row Filter
GroupBy
Variable Creator
GroupBy
Will be used here!
Constant Value Column Appender
Will be used here!
Constant Value Column Appender
Table Creator
Table Creator
Variable Creator
Table Row to Variable
Load Data
add comment column
Expression
do somecalculation
GroupBy
Will be used here!
Constant Value Column Appender
Loop End
Table Row to Variable Loop Start
Load Data
Empty Table Creator
Table Creator
Date&Time Widget
Table Column to Variable
Table Creator
Create File/Folder Variables
GroupBy
Single Selection Widget
Filter uses Variable
Row Filter
Variable Creator
do somecalculation
GroupBy
Variable Creator
Table Creator
write into sheet a
Excel Writer
Concatenate
Keep group a
Row Filter
Filter uses Variable
Row Filter
add comment column
Expression
Filter creates Variable
Row Filter
Keep group
Row Filter
Will be used here!
Constant Value Column Appender
Variable Creator
write into sheet
Excel Writer
Table Creator

Nodes

Extensions

Links