> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Fill

> Populate NULLs

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

<Steps>
  <Step title="Select Column(s)">
    Select the column(s) you want to fill. You can choose multiple columns at the same time.
  </Step>

  <Step title="Select Filling Strategy">
    Select how you want to fill the column(s) selected in Step 1. You can choose from five different methods:

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

    <Note>Number and Zero only work with Interger and Decimal columns, Text only works with Text columns while Up and Down woks with all columns types.</Note>
  </Step>
</Steps>