Icon

1. Flow_​Vars

Flow Variables
Dynamic Row Filtering via Global Flow Variables Modifying Values in Flow Variables Creating and using local Flow Vars with Configuration nodes Workflow: Flow_Vars This workflow explorescreation, manipulation, andusage of local and global flowvariables. From Data to Variables and Back sales.csvCalculate Sum(quantity) and Sum(amount) for each Country. Sort by Sum(quantity). Keep only the first row, i.e. the country with highest number of sold products.Node 47country = country in tableExtract data rows on quantityWrite results to <output_file>keep rows wherecolumn amount > column xcreating a new flow variable x=500 if USA=100 if elseFilter all rows with country with the highest number of sold productscreate new flowvariable as nameof column 0 fromthe Flow Variables tabin configuration windowmerge flow variablescountry name withhighest sold prods andcountry name fromTable Creator columnquantity = "number items"via "range checking" criterionquantity = "number items"via pattern matching crierioncreating a new flow variable x=500 if USA=100 if elsereplace flow variable "country"with "Country: <country>"replace flow variable"number items" with"number items" * 2create local flow varas the countrywith highestsum(quantity)... and back fromflow var to table row File Reader Country with highestsum(quantity) DateTimePre-processing Row Filter Filter data rows and writeresults to output file Row Filter Java Edit Variable Row Filter Table Creator Merge Variables Row Filter Row Filter Rule EngineVariable String Manipulation(Variable) Math Formula(Variable) Table Rowto Variable Variable toTable Row Dynamic Row Filtering via Global Flow Variables Modifying Values in Flow Variables Creating and using local Flow Vars with Configuration nodes Workflow: Flow_Vars This workflow explorescreation, manipulation, andusage of local and global flowvariables. From Data to Variables and Back sales.csvCalculate Sum(quantity) and Sum(amount) for each Country. Sort by Sum(quantity). Keep only the first row, i.e. the country with highest number of sold products.Node 47country = country in tableExtract data rows on quantityWrite results to <output_file>keep rows wherecolumn amount > column xcreating a new flow variable x=500 if USA=100 if elseFilter all rows with country with the highest number of sold productscreate new flowvariable as nameof column 0 fromthe Flow Variables tabin configuration windowmerge flow variablescountry name withhighest sold prods andcountry name fromTable Creator columnquantity = "number items"via "range checking" criterionquantity = "number items"via pattern matching crierioncreating a new flow variable x=500 if USA=100 if elsereplace flow variable "country"with "Country: <country>"replace flow variable"number items" with"number items" * 2create local flow varas the countrywith highestsum(quantity)... and back fromflow var to table row File Reader Country with highestsum(quantity) DateTimePre-processing Row Filter Filter data rows and writeresults to output file Row Filter Java Edit Variable Row Filter Table Creator Merge Variables Row Filter Row Filter Rule EngineVariable String Manipulation(Variable) Math Formula(Variable) Table Rowto Variable Variable toTable Row

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: BooksKNIME Advanced LuckFlow VariablesParametersflow 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!