Description | The |
Syntax | LEAD( |
Output | Varies based on input field type |
Variables
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 |
Get the value of a specified field from a subsequent row in the dataset.
Description | The |
Syntax | LEAD( |
Output | Varies based on input field type |
arg
: the field from which to fetch the next value.
LEAD(Value
) with Row Offset 1
ID | Value | LEAD |
1 | 10 | 20 |
2 | 20 | 15 |
3 | 15 | 30 |
4 | 30 | 40 |
5 | 40 | null |