Joiner Components
This directory contains 20 workflows.
Join Regexp_Like
Joins two tables based on a selected column value in the TOP input table matching a Regular Expression pattern contained in the BOTTOM input table 12 […]
KNIME Table Connector
Creates a SQL table for the supplied KNIME data table. This allows the KNIME data table to be used with SQL via the knime DB nodes. KNOWN […]
KNIME Table Connector components
Demonstration workflow for utilising KNIME Table Connector components. Connect an H2 Connector to the first KNIME Table Connector and then pass this […]
KNIME Table Session Connector
Creates a SQL table for the supplied KNIME data table. This allows the KNIME data table to be used with SQL via the knime DB nodes. KNOWN […]
KNIME Table SQL example
Example of using the KNIME Table Session Connector component to enable the execution of SQL directly against the data in the table. The component uses the […]
Regex Lookup Filter Joiner
Iterates the Lookup table on the lower port and attempts a regex match using a regex pattern on the lookup table with a column on the Source data table on […]
Reset ROWID after Joiner
Attempts to reset the ROWID to just the Specified table ROWID from prior to the last JOINER node. If the ROWID is from the concatenation of rows from […]
Workflow Demo - options for joining based on column being within range of other column
Workflow demonstrating some ways to perform a join where part of the join condition is not based on perfect equality. The Joiner node can only join using […]
Workflow Demo Joiner Components
Workflow demonstrating the use of the Joiner Components The joiners provide the following functionality: Join Between: source column BETWEEN values in […]