SQL Lag

Compute the LAG() function in a DB table in a Azure Database or Microsoft SQL server Database

Options

Lag Value
An integer value you would like to lag.
Column Name to Lag
Write the column name you would like to lag, or use the the SQL Column Names component to parametrize this with flow variables
Column Name of Appended Lag Column
Write the column name you would like to give for you lag column

Input Ports

Icon
Port with DB Query Information.

Output Ports

Icon
The output por with a Lag column

Nodes

Extensions

Links

Download

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

Download Component
On NodePit since: 2020-12-17
Last update: 2026-01-13
Created with KNIME version: v4.2.2

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

Try NodePit Runner!