Skip to main content
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

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