Icon

Parallel Column List Loop

Your porcess goes here Included column namessplit original Row IDs and chunk indexextract current row IDson chunk indexreplace current row idwith the original row idincluded column namesincluded column namebased on chunk indexSample dataadult.csvInclude columnsrateined columnsincluded columns at topOld column namesremoves duplicate columnsunkown new columncurrent itereation colulmnsInput data set column namesFinds new columnssplit original Row IDs and chunk indexextract current row IDsnew column namessplits new columnsinserts new column namesExtract number of included columns ExtractColumn Header Transpose ParallelChunk Start Regex Split RowID Group Loop Start RowID Loop End (ColumnAppend) Column Rename Row Filter Table Rowto Variable CSV Reader Column Splitter ExtractColumn Header Loop StartPreparation Column Resorter Column Aggregator Table Rowto Variable Table Rowto Variable Column Rename Column Filter Column Filter ConstantValue Column Column Resorter ExtractColumn Header Parallel ChunkEnd (multi port) ExtractColumn Header Transpose Transpose ReferenceRow Filter Regex Split RowID ReferenceRow Filter ReferenceColumn Splitter ExtractColumn Header Transpose Column Appender Insert ColumnHeader Column Appender Extract TableDimension Table Rowto Variable Your processgoes here Remove Empty Rows Empty Table Switch End IF Empty Table Creator Extract TableDimension Table Rowto Variable Table Rowto Variable Column Appender RowID RowID Your porcess goes here Included column namessplit original Row IDs and chunk indexextract current row IDson chunk indexreplace current row idwith the original row idincluded column namesincluded column namebased on chunk indexSample dataadult.csvInclude columnsrateined columnsincluded columns at topOld column namesremoves duplicate columnsunkown new columncurrent itereation colulmnsInput data set column namesFinds new columnssplit original Row IDs and chunk indexextract current row IDsnew column namessplits new columnsinserts new column namesExtract number of included columns ExtractColumn Header Transpose ParallelChunk Start Regex Split RowID Group Loop Start RowID Loop End (ColumnAppend) Column Rename Row Filter Table Rowto Variable CSV Reader Column Splitter ExtractColumn Header Loop StartPreparation Column Resorter Column Aggregator Table Rowto Variable Table Rowto Variable Column Rename Column Filter Column Filter ConstantValue Column Column Resorter ExtractColumn Header Parallel ChunkEnd (multi port) ExtractColumn Header Transpose Transpose ReferenceRow Filter Regex Split RowID ReferenceRow Filter ReferenceColumn Splitter ExtractColumn Header Transpose Column Appender Insert ColumnHeader Column Appender Extract TableDimension Table Rowto Variable Your processgoes here Remove Empty Rows Empty Table Switch End IF Empty Table Creator Extract TableDimension Table Rowto Variable Table Rowto Variable Column Appender RowID RowID

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: armingrudd
Created at: 2021-07-02
On NodePit since: 2021-07-04
Last update: 2024-12-21
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!