Skip to main content

Varicent ELT Help Center

Fill

Abstract

Add sample or placeholder data to fill in empty values.

Fill in empty values. The filled data depends on the column type:

  • Numeric. You can choose to fill empty values with a constant number, an average, a medium, or a mode.

  • Text. Fill empty values with text you specify.

  • Boolean. Fill empty values with FALSE by default, or select Fill boolean with true to fill with TRUE.

  • Date. Fill empty values with the current date or a date you specify.

When to use this tool

Use when you need sample or placeholder data, or when you need to provide default values for empty values in a column.