Icon

day45 - 66 Days of Data

04 Flow Variables

Exercise for creating and using flow variables.

Use a flow variable to customize the workflow based on the output of a previous node.

Exercise: Flow VariablesRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territoriesin 2020.1.1) Let's look for the northmost country or territory in the data. Calculate first the maximum latitudevalue in the data.1.2) Transform it into a flow variable1.3) Filter the data by this flow variable to the northmost country. Use the Rule-based Row Filter node.Which country is it? JoinedCountryData.tablecalc northmost latitudecreatemaxLatitudeflow variablefilter for the north most countryin the data setdelete"Iceland"Table Reader Math Formula Table Rowto Variable Row Filter Row Filter Exercise: Flow VariablesRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territoriesin 2020.1.1) Let's look for the northmost country or territory in the data. Calculate first the maximum latitudevalue in the data.1.2) Transform it into a flow variable1.3) Filter the data by this flow variable to the northmost country. Use the Rule-based Row Filter node.Which country is it? JoinedCountryData.tablecalc northmostlatitudecreatemaxLatitudeflow variablefilter for the north most countryin the data setdelete"Iceland"Table Reader Math Formula Table Rowto Variable Row Filter Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-10-23
On NodePit since: 2022-10-24
Last update: 2024-05-04
Created with KNIME version: v4.7.2
Tags: flow variabletable row to variable

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!