Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Loop End (Column Append)
NodeNode / LoopEnd

Loop End (Column Append)

Workflow Control Loop Support
Drag & drop
Like
Copy short link

Node at the end of a loop, collecting the intermediate results by joining the tables on their row IDs. In each iteration the node will join the current input table with the previous result. The join is based on the row ID on the incoming tables.

The typical use case of this node is that you calculate a set of new columns in the loop body and then feed only the newly created columns to this loop end node. It will join all intermediate results (the results from each iteration) using a join operation (full outer join on the RowID column). It is strongly recommended that you filter the original input data from the input as it will otherwise occur multiple times in the joined output. Use a Joiner node following this loop end node in order to join the result with the original input data (the data provided to the loop start node).

External resources

  • KNIME E-Learning Course: Section 7.2. Re-executing Workflow Parts: Loops

Node details

Input ports
  1. Type: Table
    Any datatable
    Any datatable
Output ports
  1. Type: Table
    Collected results
    Collected results from the loop body

Extension

The Loop End (Column Append) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Loop End Column Append
    This workflow demonstrates the usage of the "Loop End Column Append".
    knime > Examples > 06_Control_Structures > 04_Loops > 15_Collecting_Columns_in_Loop
  2. Go to item
    Looping over Every Column
    Data Manipulation Looping Missing Values
    This workflow demonstrates how to loop over every column from input data and replace spec…
    ipazin > Public > 2019_12_11_Looping_over_Every_Column
  3. Go to item
    Chapter 6 / Exercise 4
    Books KNIME Advanced Luck Row loop
    +4
    Here we have single files, each one containing a data column of a bigger data table. Let'…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter6 > Exercises > Exercise4
  4. Go to item
    Replacing values within a list_FORUM
    arddashti > Public > Replacing values within a list_FORUM
  5. Go to item
    Rule engine in loop test
    diaazul > Public > Rule engine in loop test
  6. Go to item
    Change structure of an excel file
    From this forum conversation: https://forum.knime.com/t/splitting-multiple-rows-by-column…
    victor_palacios > Public > Change structure of an excel file
  7. Go to item
    Rank each column by value ignoring blanks
    elsamuel > Public > Rank each column by value ignoring blanks
  8. Go to item
    Modify column names using Java Edit Variable
    Column Columns Rename
    +1
    Rename columns names using Java Edit Variable so that every column name is upper case, an…
    takbb > Public > Modify column names using Java Edit Variable
  9. Go to item
    Chapter 6 / Exercise 4
    Books KNIME Advanced Luck Row loop
    +4
    Here we have single files, each one containing a data column of a bigger data table. Let'…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter6 > Exercises > Exercise4
  10. Go to item
    Chapter 6 / Exercise 4
    Books KNIME Advanced Luck Row loop
    +4
    Here we have single files, each one containing a data column of a bigger data table. Let'…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter6 > Exercises > Exercise4
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 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 Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits