Fill from Above

In a column, fills blank cells with the last non-blank value above them.

Example

timestamp	city
market	London
1341277810	null
1343896726	null
1362374551	Paris
1427235149	null

→

timestamp	city
market	London
1341277810	London
1343896726	London
1362374551	Paris
1427235149	Paris

Configuration

The following option(s) are available when configuring this transform.

Column

Select a column from the table to fill.

Screenshot of fill from above transform configuration

Adding the Transform

Select the column by clicking on its column header in the table.
Find Fill transform under Column Manipulation group.

Alternatively, you can click on + Add Script Step on the right of the Wrangler to find Fill transform after expanding Column Manipulation group.

Screen recording of adding the fill from above transform

Key Considerations

This transform replaces the original column.
Both null and empty strings are filled with values above.
If there’s not yet a non-blank value above the blank cell, it will not fill the blank cell.

Edit and Set to Value