Skip to main content
FILL

Populates missing values in a specified field using a defined strategy, such as forward fill or backward fill

Updated over 2 weeks ago

Description

The FILL() function populates missing values in a specified field using a defined strategy, such as forward fill or backward fill. It is useful for handling missing data.

Syntax

FILL(arg)

Output

Varies based on input field type

Variables

  1. 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

Did this answer your question?