Icon

06_​Multi-Row_​Formula_​using_​Column_​Expression

Multi-Row Formula using Column Expression

Showcases the use of a new function in the Column Expression node to read data from previous and subsequent rows.

Computing Derivates for raw and smoothed data(previously would need to use a combination of LagColumn and Math Formula nodes) In KNIME 4.6 the Column Expression node was enhanced to support multi-row access, allowing to read data from previous andsubsequent rows. The example shows how this new functionality can be used to smooth data using a custom function, andhow to compute derivates of the original raw data and the data after smoothing.In essence, the new functions is column("name", offset), where offset defines the number of rows to look ahead/behind.Example below: column("Temp", -2)*0.1 + column("Temp", -1)*0.2 + column("Temp") *0.4 + column("Temp", 1) *0.2 + column("Temp", 2) *0.1 Computes three new columns: • smooth-manual-small smoothed data using the formula above • smooth-scripted-large smoothed data with much larger window size using loops • day-over-day-delta calculates day over day delta applying a simple offset Minimum Daily Temperatures DatasetThis dataset describes the minimum daily temperatures over 10 years (1981-1990) in the city Melbourne, Australia.The units are in degrees Celsius and there are 3650 observations. The source of the data is creditedas the Australian Bureau of Meteorology.https://machinelearningmastery.com/time-series-datasets-for-machine-learning/Note the "Advanced" tab to specify the size of the windowColumn Expressions File Reader Column Expressions Data Vis Computing Derivates for raw and smoothed data(previously would need to use a combination of LagColumn and Math Formula nodes) In KNIME 4.6 the Column Expression node was enhanced to support multi-row access, allowing to read data from previous andsubsequent rows. The example shows how this new functionality can be used to smooth data using a custom function, andhow to compute derivates of the original raw data and the data after smoothing.In essence, the new functions is column("name", offset), where offset defines the number of rows to look ahead/behind.Example below: column("Temp", -2)*0.1 + column("Temp", -1)*0.2 + column("Temp") *0.4 + column("Temp", 1) *0.2 + column("Temp", 2) *0.1 Computes three new columns: • smooth-manual-small smoothed data using the formula above • smooth-scripted-large smoothed data with much larger window size using loops • day-over-day-delta calculates day over day delta applying a simple offset Minimum Daily Temperatures DatasetThis dataset describes the minimum daily temperatures over 10 years (1981-1990) in the city Melbourne, Australia.The units are in degrees Celsius and there are 3650 observations. The source of the data is creditedas the Australian Bureau of Meteorology.https://machinelearningmastery.com/time-series-datasets-for-machine-learning/Note the "Advanced" tab to specify the size of the windowColumn Expressions File Reader Column Expressions Data Vis

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Lukas.Siedentop
Created at: 2022-05-24
On NodePit since: 2025-02-18
Last update: 2026-07-13
Created with KNIME version: v4.6.0
Tags: Column ExpressionsExpressionString ManipulationMulti row formulaRelease 4.6

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

Try NodePit Runner!