Icon

03_​Column_​Expressions_​for_​Data_​Manipulation-Question

Column Expressions for Data Manipulation

This is an example worklow to manipulate string values, transform numeric values, and generate new columns using the following:
1. The String Manipulation Node, the Math Formula (Multi Column) node, and the Rule Engine node for performing single data manipulation tasks
2. The Column Expressions node to replace the individual nodes

URL: Column Expressions Node https://youtu.be/_3EJ5cYdhwI

This example worklow shows how to manipulate string values, transform numeric values, and generate new columns. For more information see the workflow metadata. Find it here: View -> Description
Operation 1: String values to upper case letters
Operation 2: Round double values
Operation 3: Generate new column from values in an existing column

Operation 4: Sort the position of TimeOfWeek next to DayOfWeek

Read airline data
File Reader (deprecated)
Rule Engine
Column Filter
String Manipulation
Math Formula

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: Maarit Laukkanen
Created at: 2018-09-03
On NodePit since: 2025-11-03
Last update: 2025-11-03
Created with KNIME version: v5.8.0
Tags: ETLdata manipulationdata transformationfeature generationrulescolumn expressionsstring manipulationmath formularule enginee-learningpreprocessing

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

Try NodePit Runner!