Icon

20230515 Pikairos Table Row to Variable Loop With Rule Engine

A workflow to assign TRUE or FALSE using a rule engine based on each row of a reference table

OriginalFileCurrencyListRun ThroughEach CurrencyIndividuallyTrue or FalseDepending onWhether Currencyis presentEnd Loopand CollectData From EachIterationSort theContains CurrencyColumn InDescendingAlphabetical OrderSo That TrueAlways ComesBefore FalseGroupByColumn1 orID columnTake the FirstEntry for the OtherColumns.For the ContainsCurrency Column,This Will Be Trueif a Currencyis PresentTable Creator Table Creator Table Row ToVariable Loop Start Rule Engine Loop End Sorter GroupBy OriginalFileCurrencyListRun ThroughEach CurrencyIndividuallyTrue or FalseDepending onWhether Currencyis presentEnd Loopand CollectData From EachIterationSort theContains CurrencyColumn InDescendingAlphabetical OrderSo That TrueAlways ComesBefore FalseGroupByColumn1 orID columnTake the FirstEntry for the OtherColumns.For the ContainsCurrency Column,This Will Be Trueif a Currencyis PresentTable Creator Table Creator Table Row ToVariable Loop Start Rule Engine Loop End Sorter GroupBy

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: LAMBERT
Created at: 2023-05-15
On NodePit since: 2023-05-15
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: Rule EngineTable Row to Variable Loop Start

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

Try NodePit Runner!