PandaSQL Join

Uses Python pandasSql to join two input tables

The supplied query should reference the top input table as t1 and the lower input table as t2.

t1 is the LEFT (upper input) table in the join
t2 is the RIGHT (lower input) table in the join

e.g.
select * from t1
inner join t2 on t1.mydate between t2.date1 and t2.date2

NOTE, to use this component you must have the following installed and configured in your KNIME environment:
Python 3
numpy
pandas
pandassql

e.g. to manually install the packages, using pip, outside of KNIME
python -m pip install numpy
python -m pip install pandas
python -m pip install pandasql

27 May 2021 @takbb Brian Bates

Input ports

1. Type: Table
   Left Table t1
   The left data table to be included in the join
2. Type: Table
   Right Table t2
   The right data table to be included in the join

Output ports

1. Type: Table
   Joined Output
   The resultant output table from the joining of t1 with t2 using the supplied pandasql query