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
--------------------

Input ports

1. Type: DB Data
   DB Data (left table)
   DB Data (left table)
2. Type: DB Data
   DB Data (right table)
   DB Data (right table)

Output ports

1. Type: DB Data
   DB Data (merged)
   DB Data (merged)