Description | The |
Syntax | FILL( |
Output | Varies based on input field type |
Variables
arg
: the field to be filled.
Example
FILL(Value
)
ID | Value | FILL |
1 | 10 | 10 |
2 | NULL | 10 |
3 | 20 | 20 |
4 | NULL | 20 |
5 | 30 | 30 |
Populates missing values in a specified field using a defined strategy, such as forward fill or backward fill
Description | The |
Syntax | FILL( |
Output | Varies based on input field type |
arg
: the field to be filled.
FILL(Value
)
ID | Value | FILL |
1 | 10 | 10 |
2 | NULL | 10 |
3 | 20 | 20 |
4 | NULL | 20 |
5 | 30 | 30 |