Icon

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

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







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 caseletters Operation 2: Round double values Operation 3: Generate new column fromvalues in an existing column Operation 1 & 2 & 3 by the ColumnExpressions node Destination codeto upper caseRound Latitude and Longitudeto two decimalsFlag flights atweekends/weekdaysRead airline data String Manipulation Math Formula(Multi Column) Rule Engine Column Expressions File Reader 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 caseletters Operation 2: Round double values Operation 3: Generate new column fromvalues in an existing column Operation 1 & 2 & 3 by the ColumnExpressions node Destination codeto upper caseRound Latitude and Longitudeto two decimalsFlag flights atweekends/weekdaysRead airline data String Manipulation Math Formula(Multi Column) Rule Engine Column Expressions File Reader

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: 2023-02-06
Last update: 2024-04-26
Created with KNIME version: v4.1.1
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!