Icon

01-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 a 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

Variables with fields (lists of many values)
Example 1: Filter Data to keep three columns with largest median only
Example 2: Create List for User-Input in Components
GroupBy
Table Row to Variable
Get top 3 columns
Table Creator
Table Row to Variable
Adult Data-Set
CSV Reader
Will be used here!
Constant Value Column Appender
Create a User-Input for filtering"eductation" column
Multiple Selection Widget
Loop End
Filtering the whole Data
Reference Row Filter
Table Row to Variable Loop Start
Create Set of "education" entries
GroupBy
Empty Table Creator
Table Row to Variable
Table Creator
Date&Time Configuration
Table Column to Variable
Table Creator
Create File/Folder Variables
Single Selection Widget
do somecalculation
GroupBy
write into sheet a
Excel Writer
Keep group a
Row Filter
add comment column
Expression
Keep group
Row Filter
write into sheet
Excel Writer
Table Creator
Filter uses Variable
Row Filter
Variable Creator
GroupBy
Will be used here!
Constant Value Column Appender
Will be used here!
Constant Value Column Appender
Table Creator
Variable Creator
Load Data
add comment column
Expression
do somecalculation
GroupBy
Merge Variables
Load Data
Single Selection Configuration
Variable Creator
Variable Creator
Variable Expression
String Manipulation (Variable)
GroupBy
Just keep the top 3 columns
Column Filter
Variable Expression
Math Formula (Variable)
Filter uses Variable
Row Filter
Variable Creator
Variable Creator
Table Creator
Concatenate
Create some Test Data
Data Generator
Filter uses Variable
Row Filter
Filter creates Variable
Row Filter
Will be used here!
Constant Value Column Appender
Variable Creator
Create Set of Column Names
GroupBy
Table Creator

Nodes

Extensions

Links