Icon

Sharing Is Caring - plus component

Using a more generic component toimplement the above.Not you can configure the column nameregex pattern that identifies "repeatingcolumns" Adjust the denominator value according to howmany columns there arefor each iterationadjusted to reflect there being 3 columnsGet original column namesRename columnsbased on original tableTurn into a lookup table(we will only be interested in Column 0 and Column 1in this exampleBut the subsequent insert column header will use as many rowsas it requires to rename the headersTo reset the header names.Otherwise you'll end upwith additional columns.Extended example data set 3 columns in originaland 3 iterations Transpose Math Formula Loop End Group Loop Start Transpose Column Filter ExtractColumn Header Insert ColumnHeader Transpose ExtractColumn Header Fix Table AfterColumn Append Table Creator Using a more generic component toimplement the above.Not you can configure the column nameregex pattern that identifies "repeatingcolumns" Adjust the denominator value according to howmany columns there arefor each iterationadjusted to reflect there being 3 columnsGet original column namesRename columnsbased on original tableTurn into a lookup table(we will only be interested in Column 0 and Column 1in this exampleBut the subsequent insert column header will use as many rowsas it requires to rename the headersTo reset the header names.Otherwise you'll end upwith additional columns.Extended example data set 3 columns in originaland 3 iterationsTranspose Math Formula Loop End Group Loop Start Transpose Column Filter ExtractColumn Header Insert ColumnHeader Transpose ExtractColumn Header Fix Table AfterColumn Append Table Creator

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: USER
Created at: 2022-09-28
On NodePit since: 2022-09-29
Last update: 2024-04-27
Created with KNIME version: v4.6.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!