Icon

20221124 Pikairos How to filter rows based on a list of terms using the Cross Joiner and Rule Base filter nodes

20221124 Pikairos How to filter rows based on a list of terms using the Cross Joiner and Rule Base filter nodes
List of CitiesList of KeywordsCross Joinboth TablesSelect onlyMatching CitiesIf the list of citiesis too big to directlyuse a Cross-Joinerthen add a-Chunk Loop- nodeto split the job into chunksThe result hereshould be the sameas aboveSelect onlyMatching Cities:$keyword$ LIKE $Cities$ => TRUECross Joinboth TablesFinal SelectionSolution (1)Final SelectionSolution (2)Table Creator Table Creator Cross Joiner Rule-basedRow Filter Chunk Loop Start Loop End Rule-basedRow Filter Cross Joiner InteractiveTable (local) InteractiveTable (local) List of CitiesList of KeywordsCross Joinboth TablesSelect onlyMatching CitiesIf the list of citiesis too big to directlyuse a Cross-Joinerthen add a-Chunk Loop- nodeto split the job into chunksThe result hereshould be the sameas aboveSelect onlyMatching Cities: $keyword$ LIKE $Cities$ => TRUECross Joinboth TablesFinal SelectionSolution (1)Final SelectionSolution (2)Table Creator Table Creator Cross Joiner Rule-basedRow Filter Chunk Loop Start Loop End Rule-basedRow Filter Cross Joiner InteractiveTable (local) InteractiveTable (local)

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: thomas
Created at: 2022-11-22
On NodePit since: 2022-11-24
Last update: 2024-04-30
Created with KNIME version: v4.5.2
Tags: Cross JoinerRule based row filter

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

Try NodePit Runner!