Icon

Using virtual db instead of cross join and rule-based filter

Using virtual db instead of cross join and rule-based filter

Using virtual db instead of cross join and rule-based filter

Scenario: We have a loopup table of Cities and we want to retrieve the cities whose name starts with a given list from a table Requests.

Solutions:
1. Typically, using Knime nodes, since it is not an exact match, we cannot do a join. Instead, we would:
(i). Do a cross join between the 2 tables;
(ii). Apply a rule-based filter;

2. Alternatively, we can load the tables in a virtual DB (in memory), for example H2, and do SQL-style JOIN

Scenario: We have a loopup table of Cities and we want to retrieve the cities whose name starts with a given list from a table Requests.Solutions:1. Typically, using Knime nodes, since it is not an exact match, we cannot do a join. Instead, we would: (i). Do a cross join between the 2 tables; (ii). Apply a rule-based filter;2. Alternatively, we can load the tables in a virtual DB (in memory), for example H2, and do SQL-style JOIN CitiesRequestsNode 3Node 4Node 5Node 6 Table Creator Table Creator H2 Connector DB Writer DB Writer DB Query Reader Scenario: We have a loopup table of Cities and we want to retrieve the cities whose name starts with a given list from a table Requests.Solutions:1. Typically, using Knime nodes, since it is not an exact match, we cannot do a join. Instead, we would: (i). Do a cross join between the 2 tables; (ii). Apply a rule-based filter;2. Alternatively, we can load the tables in a virtual DB (in memory), for example H2, and do SQL-style JOIN CitiesRequestsNode 3Node 4Node 5Node 6Table Creator Table Creator H2 Connector DB Writer DB Writer DB Query 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: bruno
Created at: 2022-06-10
On NodePit since: 2022-06-11
Last update: 2024-05-02
Created with KNIME version: v4.5.2

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

Try NodePit Runner!