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.

Views

This node has no views

Workflows

• 01.2 Database Extension and In-Spark ProcessingKNIME Hub
• 22_DB_ConcatenateKNIME Hub
• EAV RivadisKNIME Hub
• H2_baseKNIME Forum
• Integrated deployment for ETLKNIME Hub
• Show all 14 workflows

Links

• No links available

Developers