Icon

2 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.

Column Rename (Regex)#4Search String (regexp):Master_idReplacement:ANONYMOUS_COLUMNcheck LiteralFlow Variable Tab:searchStringcurrentColumnName Column Filter #2IncludeSelect:Select all columnsunder IncludeThen check Enforce Inclusion String Manipulation #5Expression:regexReplace($ANONYMOUS_COLUMN$,"[^\\x00-\\x7F]+","")Check Replace Column and Select: ANONYMOUS_COLUMNCheck syntax check on close File Reader #1Settings:Read ColumnHeadersIgnore Spaces andtabsColumn delimiter: ,Advanced..." (quotes)Check Allow multi linequoted string Column List Loop Start#3IncludeSelect:Select all columns underIncludeThen check Enforce InclusionCheck run one iteration Loop End (Column Append)#7 Loop End Configurationcheck Loop has same Row IDin each iteration Column Rename(Regex)#6Search String (regexp):ANONYMOUS_COLUMNReplacement: Master_idcheck LiteralFlow Variable Tab:replaceStringcurrentColumnName String Manipulation #8Expression:regexReplace($Secondary_id_text$, "^\\s*$", "NO INFO")Check Replace Column and Select:$Secondary_id_textCheck syntax check on close String Manipulation #9Expression:regexReplace($Secondary_id_value$, "^\\s*$", "NOINFO")Check Replace Column and Select:$Secondary_id_valueCheck syntax check on close CSV Writer #10Location:Select LOcation andName the File.Write Option:Write Column HeaderCheck Overwrite rename toANONYMOUS_COLUMN(current column is given as a variable)revert nameone columnat a timeNode 11Node 14Node 17Node 18Node 19Node 20Node 21 Column Rename(Regex) Column Rename(Regex) Column ListLoop Start Loop End (ColumnAppend) CSV Writer String Manipulation Column Filter File Reader String Manipulation String Manipulation Column Rename (Regex)#4Search String (regexp):Master_idReplacement:ANONYMOUS_COLUMNcheck LiteralFlow Variable Tab:searchStringcurrentColumnName Column Filter #2IncludeSelect:Select all columnsunder IncludeThen check Enforce Inclusion String Manipulation #5Expression:regexReplace($ANONYMOUS_COLUMN$,"[^\\x00-\\x7F]+","")Check Replace Column and Select: ANONYMOUS_COLUMNCheck syntax check on close File Reader #1Settings:Read ColumnHeadersIgnore Spaces andtabsColumn delimiter: ,Advanced..." (quotes)Check Allow multi linequoted string Column List Loop Start#3IncludeSelect:Select all columns underIncludeThen check Enforce InclusionCheck run one iteration Loop End (Column Append)#7 Loop End Configurationcheck Loop has same Row IDin each iteration Column Rename(Regex)#6Search String (regexp):ANONYMOUS_COLUMNReplacement: Master_idcheck LiteralFlow Variable Tab:replaceStringcurrentColumnName String Manipulation #8Expression:regexReplace($Secondary_id_text$, "^\\s*$", "NO INFO")Check Replace Column and Select:$Secondary_id_textCheck syntax check on close String Manipulation #9Expression:regexReplace($Secondary_id_value$, "^\\s*$", "NOINFO")Check Replace Column and Select:$Secondary_id_valueCheck syntax check on close CSV Writer #10Location:Select LOcation andName the File.Write Option:Write Column HeaderCheck Overwrite rename toANONYMOUS_COLUMN(current column is given as a variable)revert nameone columnat a timeNode 11Node 14Node 17Node 18Node 19Node 20Node 21 Column Rename(Regex) Column Rename(Regex) Column ListLoop Start Loop End (ColumnAppend) CSV Writer String Manipulation Column Filter File Reader String Manipulation String Manipulation

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: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.1.3

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

Try NodePit Runner!