The Fill in blanks step uses the nearest value above, below, to the left, or to the right of a cell in a column. You can also use a custom value or reference another column's value to fill in the blank cell.

Fill in blanks

Input/output

We'll use the below input table for this step to process. It contains four columns including an empty one called "Gender".



After using the Fill in blanks step, our output table now has values in the previously-empty "Gender" column. "Gender" has been populated by specified based on Fill blank rules.



Settings

Once you connect data to the Fill in blanks step, you will first need to Pick the dataset, then select which column we should fill in blanks for.

By default, this step will fill in blanks with values from above. To change this, click on values from above and select another option from the available dropdown:

values from above
values from below
custom values

Was this article helpful?
Cancel
Thank you!