The Fill tool can be used to get rid of null values in your dataset. You can use a variety of filling options to either populate nulls with a fixed value or to dynamically fill your null values with the other values of your dataset.

​
Configuration

The Fill tool consists of two required input.

1

Select Column(s)

Select the column(s) you want to fill. You can choose multiple columns at the same time.

2

Select Filling Strategy

Select how you want to fill the column(s) selected in Step 1. You can choose from four different methods:

  • Value: use this option to hardcode a static value. Note that this transforms the column to a text/string column.
  • Zero: use this option to input zero in your null columns. This option only works with whole number/integer and decimal/float columns.
  • Forward: use this option to fillcell values forward/down in your dataset. See the Examples below for context.
  • Backward: use this option to fill cell values backward/up in your dataset. See the Examples below for context.

​
When To Use

You can use the Fill tool for a wide variety of use cases.

  • You want to populate you null values with a 0 for calcalations
  • You have a header column and want to populate all the next values with that header value (forward fill)
  • You have a exchange rate table and want to populate weekend rates with the coming Monday’s rate (backward fill)
  • You want to fill your null text/string columns with a “missing” keyword

​
Examples