Icon

Exercise2

Chapter 5 / Exercise 2
Workflow: Chapter5/Exercise2 This exercise:- uses a global variable (username), - creates a local variable (timestamp <today>) with a Java Edit Variable node, - performs parametric row filtering transforming a resulting data row into a flow variable and using as the dynamic pattern forrow filtering. Find car manifacturer with lowest number of contracts (# data rows) Find car manifacturer with highest number of contracts (# data rows) by count, descending1st row onlydata rows from least represented makeby count, ascending1st row onlydata rows from most represented makecount by makecount by makeread filecars-85.csvin KCBdatacars frommost and least represented makecreate date <today>as local flow varusing java datetime library"make" only"make" onlyappend usernameas from global varsappend timestampload_date = todayNode 32Node 33 Sorter Row Filter Row Filter Sorter Row Filter Row Filter GroupBy GroupBy File Reader Concatenate Java EditVariable (simple) Column Filter Column Filter Rule Engine Rule Engine Table Rowto Variable Table Rowto Variable Workflow: Chapter5/Exercise2 This exercise:- uses a global variable (username), - creates a local variable (timestamp <today>) with a Java Edit Variable node, - performs parametric row filtering transforming a resulting data row into a flow variable and using as the dynamic pattern forrow filtering. Find car manifacturer with lowest number of contracts (# data rows) Find car manifacturer with highest number of contracts (# data rows) by count, descending1st row onlydata rows from least represented makeby count, ascending1st row onlydata rows from most represented makecount by makecount by makeread filecars-85.csvin KCBdatacars frommost and least represented makecreate date <today>as local flow varusing java datetime library"make" only"make" onlyappend usernameas from global varsappend timestampload_date = todayNode 32Node 33 Sorter Row Filter Row Filter Sorter Row Filter Row Filter GroupBy GroupBy File Reader Concatenate Java EditVariable (simple) Column Filter Column Filter Rule Engine Rule Engine Table Rowto Variable Table Rowto Variable

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2020-05-26
Last update: 2024-04-24
Created with KNIME version: v4.1.2
Tags: KNIME Advanced LuckBooksexerciseETLflow variablesflow control

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

Try NodePit Runner!