DB Concatenate

This node concatenates two 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

Use union of columns

Use all columns available in the input tables. Fill rows with missing values if they miss cells for some columns.

Use intersection of columns

Use only the columns that appear in both input tables. Any other column is ignored and won't appear in the output table.

Remove duplicate rows

Removes duplicated rows from the output table. Union SQL operator will be used.

Keep all rows

Keeps duplicated rows in the output table. Union All SQL operator will be used.

Views

This node has no views

Workflows

• 22_DB_ConcatenateKNIME Hub
• H2_baseKNIME Forum
• Integrated deployment for ETLKNIME Hub
• KNIME_Forum_241217KNIME Hub
• KNIME_project_database_excel_joinKNIME Forum
• Show all 11 workflows

Links

• No links available

Developers