Icon

Some options for non-equality joins

Options for non-equality joins using SQL

Workflow showing some options for providing joins between tables using SQL to achieve a non-equality join

Using a python component. Requires Python 3,pandas, pandasql, numpy installed. Seecomponent description for info Slightly more involved but doesn't require anyspecial installation.H2 is just an example. Equivalent can be donewith sqllite etc Join using SQLTable 1Table 2Create an H2 databasePut table1 into H2Put table2 into H2Join using SQLThis is ok provideddata sets aren't too largecreate wildcardpatternKeep rows thatmatchMake our serial nosinto Strings toallow pattern matchingPandaSQL Join Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text H2 Connector DB Writer DB Writer DB Query Reader Cross Joiner String Manipulation Rule-basedRow Filter Number To String Using a python component. Requires Python 3,pandas, pandasql, numpy installed. Seecomponent description for info Slightly more involved but doesn't require anyspecial installation.H2 is just an example. Equivalent can be donewith sqllite etc Join using SQLTable 1Table 2Create an H2 databasePut table1 into H2Put table2 into H2Join using SQLThis is ok provideddata sets aren't too largecreate wildcardpatternKeep rows thatmatchMake our serial nosinto Strings toallow pattern matchingPandaSQL Join Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text H2 Connector DB Writer DB Writer DB Query Reader Cross Joiner String Manipulation Rule-basedRow Filter Number To String

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: BATEB031
Created at: 2022-10-25
On NodePit since: 2022-10-27
Last update: 2024-11-21
Created with KNIME version: v4.6.3

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

Try NodePit Runner!