Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Column Appender
NodeNode / Manipulator

Column Appender

Manipulation Column Split & Combine Streamable
Drag & drop
Like
Copy short link

The Column Appender takes two or more tables and quickly combines them by appending their columns according to the order of the tables at the input ports. It simply appends columns from the second input table to the first input table and does the same for any subsequent table if additional (dynamic) ports were added. The node performs a simple and straight forward join operation but can be faster 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 tables will be appended with "(#1), (#2) and so on".

Node details

Input ports
  1. Type: Table
    Table 0
    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 1
    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 all input tables (Table 0, Table 1, Table ...)
input (Dynamic Inport)
Table contributing subsequent columns.
  1. Type: Table

Extension

The Column Appender node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Numeric_Scorer
    GIDS Exercise Academia
    +2
    Numeric scorer: compare performance of two regression models
    knime > Academic Alliance > Guide to Intelligent Data Science > Exercises > Chapter5_Principles_of_Modeling > Numeric_Scorer_Solution
    knime
  2. Go to item
    custom_time_stamp
    marten_kose > Public > misc > custom_time_stamp
    marten_kose
  3. Go to item
    Add page number to parsed pdf
    kathrin > Forum Questions > Add page number to parsed pdf
    kathrin
  4. Go to item
    String replace
    lelloba > Forum > String replace
    lelloba
  5. Go to item
    sub2
    kowisoft > Public > villain workflows > subs > sub2
    kowisoft
  6. Go to item
    sub1
    kowisoft > Public > villain workflows > subs > sub1
    kowisoft
  7. Go to item
    Challenge 19
    jcanelhas > Public > Challenge 19
    jcanelhas
  8. Go to item
    justknimeit-28
    Justknimeit-28
    si_daniel_a > Public > justknimeit-28
    si_daniel_a
  9. Go to item
    Yearly Revenue Breakdown
    Financial Data Data Manipulation Yearly Data Reconciliation
    This workflow demonstrates breaking down yearly revenue on months based on closing date. …
    ipazin > Public > 2021_02_17_Yearly_Revenue_Breakdown
    ipazin
  10. Go to item
    PeriodInOut
    IN OUT PERIOD COMPARISON
    Suggested workflow example for dealing with comparing IN and OUT of one month with anothe…
    takbb > Public > PeriodInOut
    takbb

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits