DB Concatenate

This node concatenates two or more database tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated (if the column types differ the column type is the common base type of both input column types). If one input table contains column names that the other table does not, the columns can either be filled with missing values or filtered out, i.e. they will not be in the output table.

Options

How to combine input columns
Choose the output column selection process:
  • Union: Use all columns from all input tables. Fill rows with missing values if they miss cells for some columns.
  • Intersection: Use only the columns that appear in every input table. Any other column is ignored and won't appear in the output table.
Row handling
Choose how to handle RowIDs:
  • Keep all: Keeps duplicated rows in the output table. Union All SQL operator will be used
  • Remove duplicates: Removes duplicated rows from the output table. Union SQL operator will be used.

Input Ports

Icon
First DB Data Table to concatenate.
Icon
Second DB Data Table to concatenate.
Icon
Additional DB Data Tables to concatenate.

Output Ports

Icon
Concatenated DB Data tables.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.