Icon

03_​Looping_​over_​all_​columns_​and_​manipulation_​of_​each

Looping over all columns and manipulation of each

The workflow iterates over all numeric columns and negates the values in the column. The loop takes one column at a time, renames the column name to ANONYMOUS_COLUMN in the first rename node, changes the value in the math formula nodes and reverts the name to the original column name.

Looping over all columns and manipulation of each The workflow iterates over all numeric columns and negates the values in the column. Theloop takes one column at a time, renames the column name to ANONYMOUS_COLUMN inthe first rename node, changes the value in the math formula nodes and reverts the name tothe original column name. The columns are collected in the loop end node and finally joined with the unmodified part ofthe original input table. random datarename toANONYMOUS_COLUMN(current column is given as a variable)revert namesome mathattach unmodified columnsall columns ofinterest go top outputone columnat a timeNode 11 Data Generator Column Rename(Regex) Column Rename(Regex) Math Formula Joiner Column Splitter Column ListLoop Start Loop End (ColumnAppend) Looping over all columns and manipulation of each The workflow iterates over all numeric columns and negates the values in the column. Theloop takes one column at a time, renames the column name to ANONYMOUS_COLUMN inthe first rename node, changes the value in the math formula nodes and reverts the name tothe original column name. The columns are collected in the loop end node and finally joined with the unmodified part ofthe original input table. random datarename toANONYMOUS_COLUMN(current column is given as a variable)revert namesome mathattach unmodified columnsall columns ofinterest go top outputone columnat a timeNode 11 Data Generator Column Rename(Regex) Column Rename(Regex) Math Formula Joiner Column Splitter Column ListLoop Start Loop End (ColumnAppend)

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2019-07-12
Last update: 2024-04-26
Created with KNIME version: v3.1.0

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

Try NodePit Runner!