Icon

03 Flow Variables

03 Flow Variables
Exercise: Flow VariablesRead the WA_Fn-UseC-IT-Help-Desk.csv data by executing the CSV Reader node. Filter the data tothe listings of the requestor with the most tickets:1) Count the number of tickets by requestor2) Sort the aggregated data descending by the count of tickets, then ascending by requestor3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the requestorflow variable. How many tickets does this requestor have? 74 What is the requestor's seniority? 2-Regular countby requestorsort descendingfilter to toprequestorWA_Fn-UseC-IT-Help-Desk.csv GroupBy Sorter Row Filter Table Rowto Variable CSV Reader Exercise: Flow VariablesRead the WA_Fn-UseC-IT-Help-Desk.csv data by executing the CSV Reader node. Filter the data tothe listings of the requestor with the most tickets:1) Count the number of tickets by requestor2) Sort the aggregated data descending by the count of tickets, then ascending by requestor3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the requestorflow variable. How many tickets does this requestor have? 74 What is the requestor's seniority? 2-Regular countby requestorsort descendingfilter to toprequestorWA_Fn-UseC-IT-Help-Desk.csvGroupBy Sorter Row Filter Table Rowto Variable CSV Reader

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-26
On NodePit since: 2022-03-11
Last update: 2024-11-18
Created with KNIME version: v4.5.1
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!