Concatenate

This node concatenates two or more tables. The table at inport 0 is the first input table (top input port), and the tables at subsequent inports are the additional input tables. Columns with the same names are concatenated (if the column types differ, the resulting column type will be the common base type of the input column types). If one input table contains column names that the other tables do not, the columns can either be filled with missing values or filtered out, meaning they will not appear in the output table. The dialog allows setting the following parameters:

Options

How to combine input columns

• 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 all input tables. Any other column is ignored and won't appear in the output table. Columns are matched by name.

RowID handling

Choose how to handle RowIDs:

• Create new: Discard the RowIDs of the input tables and generate new RowIDs
• Reuse existing: Reuse the RowIDs of the input tables. This might lead to conflicts due to duplicate RowIDs, see Duplicate RowID strategy for different ways to resolve them.

Duplicate RowID strategy

Select how duplicate RowIDs are handled:

• Append suffix: The output table will include all rows, but duplicate RowIDs will have a suffix added. This method is also memory intensive, similar to the "Skip" option.
• Skip: Duplicate RowIDs in the additional tables are not added to the output table. This option is memory intensive because it caches the RowIDs to find duplicates and requires full data duplication.
• Fail: The node will fail during execution if duplicate RowIDs are encountered. This option is efficient for checking uniqueness.

Enable hiliting

Advanced setting that enables hiliting between the inputs and the concatenated output table.

Views

This node has no views

Workflows

• _01_PMR_AnalysisKNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflowKNIME Hub
• (test) credit score modelKNIME Hub
• [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
• Show all 5599 workflows

Links

• How to combine multiple nodes into 1 excel sheet?by izaychik63 on 2020-10-11

  forum.knime.com/p/105278
• merge columns with different databy armingrudd on 2020-05-14

  forum.knime.com/p/91114
• Merging multiples excel files with different columnsby armingrudd on 2019-06-24

  forum.knime.com/p/62832
• How can I add a table under another one?by qqilihq on 2020-08-10

  forum.knime.com/p/99473
• How to use String Manipulation on a specific cell within Table Creatorby AnotherFraudUser on 2020-05-21

  forum.knime.com/p/92094
• Show all 19 links

Developers