DB Full Outer Join and Merge Columns

This node joins two DB Data tables (using a FULL OUTER JOIN) and merges columns (using a COALSCE statement) with indentical names.

Input columns with identical names should be of the identical data types, however, if different the merge will be attempted using the DB Data (left table) as the data type.

Tested on H2 and Amazon Redshift Database.

--------------------
Example SQL statement performed:

SELECT

COALESCE(left_column::data-type, right_column::data-type) AS column_name

FROM left_table

FULL OUTER JOIN right_table
ON left_column = right_column
--------------------

Options

Right join column: Name of right join column
Left join column: Name of left join column

Input Ports

: DB Data (left table)
: DB Data (right table)

Output Ports

: DB Data (merged)

Nodes

String Manipulation3 ×
DB Query (Labs)2 ×
Row Splitter2 ×
String Configuration2 ×
Cell Replacer1 ×
Show all 17 nodes

Extensions

FeatureKNIME Base nodes
FeatureKNIME Database
FeatureKNIME Javasnippet
FeatureKNIME Quick Forms