Icon

Concatenate Columns by name

Node 1Find all columns matchingbeginning ^N_\d+Determine column namefor NP_ column.This flow variable is used todefine output column namein subsequent Column ExpressionsConcatenate N_ with equivalentP_ column(P column + N column)and output to NP_ cocolumn defined by flow variableAllow throughonly the newlycreated output columnsJoin newcolumns on endof each row, by rowidBuild up set of new columnsExcel Reader Column ListLoop Start String Manipulation(Variable) Column Expressions Column Filter Joiner Loop End (ColumnAppend) Node 1Find all columns matchingbeginning ^N_\d+Determine column namefor NP_ column.This flow variable is used todefine output column namein subsequent Column ExpressionsConcatenate N_ with equivalentP_ column(P column + N column)and output to NP_ cocolumn defined by flow variableAllow throughonly the newlycreated output columnsJoin newcolumns on endof each row, by rowidBuild up set of new columnsExcel Reader Column ListLoop Start String Manipulation(Variable) Column Expressions Column Filter Joiner 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
Created by: brian
Created at: 2021-08-04
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.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!