Node at the end of a loop, collecting the intermediate results by joining the tables on their RowIDs. In each iteration the node will join the current input table with the previous result. The join is based on the RowID on the incoming tables.
\n \nThe 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).
\n \n \n ","shortDescription":"Node at the end of a loop, collecting the intermediate results by joining the tables on their RowIDs.","keywords":[],"deprecated":false,"streamable":false,"tags":["Workflow Control","Loop Support"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NEFDQzk2NDM4NDlBMTFFNTlCODZDMzA0NTY3MzY5QkQiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NEFDQzk2NDI4NDlBMTFFNTlCODZDMzA0NTY3MzY5QkQiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3Q0JCOUFENDQ1QzcxMUU1QUM2QkE3NzQyQjhFM0EyRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MkZFNkZENDQ1QzcxMUU1QUM2QkE3NzQyQjhFM0EyRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pm9AWPwAAAFpSURBVHjapFPLSsNQEJ2btMWWEmIR8bERwa/wF6rVTdSVustHuPYXdCVKF9JutCLiQvBHpLuWoqYGrLa0odczcSKNj0DrwHAvd845mQxnFI1Ec72Uu3ny3lZti6x0mhTeNPI1CMhKpcq4ugtXtfcIr7UOMRG5hKOKzJBSZBYKpPJ50p0OBZ4XAftIByK1mICQL5Dq9rlN+/d3kMl8dZY1TaoX1yq4bklTmyzCAga3LV9msb2Dh3qMzNEbDgmEba4Lrio8MpDHYdtEFYDOmo8N+iu4juNc8MwjBaU2ThuZA6D3+Ws6RlQq/NNoprEwhNwQ8thhiPILTRiGtDX9HwGf54NZTE0qcC3nSTjp2cUkPA/9EsneKWPYiomuOGwHj7tJbNQZuyF4N+xAvO3ILE4PV5ZR7seISzPzTGanHgnOiXbi111gRKvbJX8wIBtLNZfNJu/C6DaKw4rij8g8vszq5zZ+d9248SHAAHHOlHnBuEbCAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Any datatable","description":"Any datatable."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Collected results","description":"Collected results from the loop body."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Loop has same RowIDs in each iteration","description":"Check this box if the tables in each iteration have the same number of rows and the same row ordering. If this option is selected, the node does not use an expensive join (requires table sorting) but only puts tables side-by-side. This option does not have any influence on the output table. If the tables do not have the same RowIDs and this option is selected, the node will fail during execution.","optional":false},{"name":"Propagate modified loop variables","description":"If checked, variables whose values are modified within the loop are exported by this node. These variables must be declared outside the loop, i.e. injected into the loop from a side-branch or be available upstream of the corresponding loop start node. For the latter, any modification of a variable is passed back to the start node in subsequent iterations (e.g. moving sum calculation). Note that variables defined by the loop start node itself are excluded as these usually represent loop controls (e.g. "currentIteration").","optional":false}]}],"links":[{"text":"KNIME Flow Control Guide: Section Loops","url":"https://docs.knime.com/latest/analytics_platform_flow_control_guide/index.html#loops"}],"kudos":[{"accountId":"account:user:552210dd-3dfc-4b47-bbe6-477d972e6b9e","user":"nilotpalc","date":"2022-05-31T14:57:36+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.17721518987341772},{"id":"*_zMUh-EpYjdvFKW9","factoryName":"org.knime.base.node.preproc.columnappend.ColumnAppenderNodeFactory","probability":0.09321058688147296},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.08745684695051784},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.06444188722669736},{"id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","probability":0.03222094361334868},{"id":"*laI6npAqSiKLMn5S","factoryName":"org.knime.base.node.preproc.split2.SplitNodeFactory2","probability":0.02761795166858458},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.023014959723820484},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.018411967779056387},{"id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","probability":0.018411967779056387},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.018411967779056387}]}