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
Used extensions & nodes
Created with KNIME Analytics Platform version 4.5.2
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.