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