Icon

Exercise1

<p><strong>Chapter 5/Exercise 1</strong></p><p>This exercise shows how to transform data values into flow variables and then uses the created flow variables to dynamically overwrite the configuration in the Row Filter node to filter the input data by month and year.</p><p>Change the input values 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>.</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>

Parametric filtering by month & year

Workflow: Chapter 5/Exercise 1


This exercise shows how to transform data values into flow variables and then uses the created flow variables to dynamically overwrite the configuration in the Row Filter node to filter the input data by month and year.

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

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

Note:

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

Reading data

Extract Month and Year
Date&Time Part Extractor
Filter data by month and yearusing flow variable
Row Filter
Input amonth & year
Table Creator
Convert intoflow variables
Table Row to Variable
Convert intoDate object
String to Date&Time
Create month & yearflow variables
Variable Creator
sales.csv
CSV Reader

Nodes

Extensions

Links