Hub
NodeNode / Manipulator

Column Appender (deprecated)

Manipulation Column Split & Combine Streamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like
Copy short link

The Column Appender takes two tables and quickly combines them by appending the columns of the second table to the first table. It performs a similar function to the Joiner but can be faster for large tables. However, it only should be used if certain preconditions are met. For more details please read the description of the "Identical row keys and table lengths"-option below. When in doubt, use the Joiner.
If the input tables share some column names, the offending column names from the bottom table will be appended with "(#1)".

Node details

Input ports
  1. Type: Table
    Table 1
    If the option "Identical row keys and table lengths" is checked: a sorted table with n rows. Otherwise a table without restrictions.
  2. Type: Table
    Table 2
    If the option "Identical row keys and table lengths" is checked: Another sorted table with n rows. Otherwise a table without restrictions.
Output ports
  1. Type: Table
    Appended table
    A table with the columns from both Table 1 and Table 2

Extension

The Column Appender (deprecated) node is part of this extension:

Related workflows & nodes

  1. Example workflow
    elsamuel > Public > sgilmour > Example workflow
    elsamuel
  2. Splitting Multiple Collection Columns
    Collections Lists Splitting Columns
    +2
    This workflow demonstrates how to split multiple collection column using loop. Inside loo…
    ipazin > Public > 2020_03_03_Splitting_Multiple_Collection_Columns
    ipazin
  3. ExcelRelativeFormulaInput
    mkoatwork > Public > TricksAndTipps > ExcelRelativeFormulaInput
    mkoatwork
  4. RunOverMultipleColumns
    mkoatwork > Public > TricksAndTipps > RunOverMultipleColumns
    mkoatwork
  5. Append Excel Sheet
    Append Excel sheet Download file from KNIME Server
    This workflow downloads an Excel file into a temporary directory and appends a new sheet …
    moritz.heine > Public > Append Sheet to Excel File > Append_Excel_Sheet
    moritz.heine
  6. json_parsing
    elsamuel > Public > JSON parsing > json_parsing
    elsamuel
  7. 01_Android_vs_iOS
    knime > Examples > 40_Partners > 03_ScientificStrategy > 01_Android_vs_iOS
    kilian.thiel
  8. last edit information
    This workflow provides information on when a workflow has been changed last. It also give…
    marten_kose > Public > forum_topics > last_workflow_editor > get_last_editor
    marten_kose
  9. Extracting Minimum and corresponding Index
    Excel Column Names
    This workflow demonstrates how to extract Index (Column Name) after calculating minimum v…
    ipazin > Public > 2019_08_14_ExtractingMinimum&IndexFromColumns
    ipazin
  10. Xpath return missing
    mwiegand > Public > Bugs > Xpath return missing
    mwiegand