Icon

Exercise3

<p><strong>Chapter 5/Exercise 3</strong></p><p>This exercise shows how to <strong>create</strong>, <strong>apply</strong>, and <strong>manipulate </strong>various flow variables and then uses the created flow variables to dynamically overwrite the configuration in the<em> Row Filter</em> nodes to filter the input data by engine size.</p><p>Change the input value in the <em>Table Creator</em> node and re-execute the workflow to see how it changes the output table of the <em>Row Filter</em> nodes.</p><p><strong><em>Note.</em></strong> The <em>Variable Creator</em> node allows to create flow variables directly, while the <em>Table Creator</em> node first creates a data table.</p>

Workflow: Chapter 5/Exercise 3


This exercise shows how to create, apply, and manipulate various flow variables and then uses the created flow variables to dynamically overwrite the configuration in the Row Filter nodes to filter the input data by engine size.

Change the input value in the Table Creator node and re-execute the workflow to see how it changes the output table of the Row Filter nodes.

Note. The Variable Creator node allows to create flow variables directly, while the Table Creator node first creates a data table.

Note:

The Variable Creator node allows to create flow variables directly, while the Table Creator node first creates a data table.

Create flow variables: month and year

Reading data

Manipulating flow variables

Parametric filtering by engine size

engine_size betweenmax4 & max2
Row Filter
Define maxengine size
Table Creator
Convert intoflow variable
Table Row to Variable
cars-85.csv
CSV Reader
Create max enginesize flow variable
Variable Creator
engine_size betweenmax2 & max
Row Filter
engine size / 2
Variable Expression
engine size / 4
Variable Expression

Nodes

Extensions

Links