Skip to main content
LEAD

Get the value of a specified field from a subsequent row in the dataset.

Updated over 2 weeks ago

Description

The LEAD() function returns the value of a specified field from a subsequent row in the dataset. It is useful for comparing current values to future ones.

Syntax

LEAD(arg)

Output

Varies based on input field type

Variables

  1. arg: the field from which to fetch the next value.

Example

LEAD(Value) with Row Offset 1

ID

Value

LEAD

1

10

20

2

20

15

3

15

30

4

30

40

5

40

null

Did this answer your question?