Icon

Modify column names using Java Edit Variable

Modify column names using Java Edit Variable
Modify Column Names using Java Edit VariableReplace spaces in column names with _ underscores and other namemanipulations, such as convert to upper caseAn solution using [Java Edit Variable] and [Column Rename (Regex)]Brian Bates @takbb 31 March 2021 Sample data starts out with the followingcolumn names:JobCompany NameYear of Startingperson_id On completion, the data set has thefollowing column names:JOBCOMPANY_NAMEYEAR_OF_STARTINGPERSON_ID Manual table containing sample dataRenamed columnsReplace currentColumnNamewith newColumnNameLoop through columnsCreate new flow variable withspaces converted to underscoresand allUPPER CASEWrite the result Table Creator Loop End (ColumnAppend) Column Rename(Regex) Column ListLoop Start Java Edit Variable CSV Writer Modify Column Names using Java Edit VariableReplace spaces in column names with _ underscores and other namemanipulations, such as convert to upper caseAn solution using [Java Edit Variable] and [Column Rename (Regex)]Brian Bates @takbb 31 March 2021 Sample data starts out with the followingcolumn names:JobCompany NameYear of Startingperson_id On completion, the data set has thefollowing column names:JOBCOMPANY_NAMEYEAR_OF_STARTINGPERSON_ID Manual table containing sample dataRenamed columnsReplace currentColumnNamewith newColumnNameLoop through columnsCreate new flow variable withspaces converted to underscoresand allUPPER CASEWrite the result Table Creator Loop End (ColumnAppend) Column Rename(Regex) Column ListLoop Start Java Edit Variable CSV Writer

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-03-31
On NodePit since: 2021-03-31
Last update: 2024-11-21
Created with KNIME version: v4.3.2
Tags: ColumnColumnsRenameHeadings

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

Try NodePit Runner!