Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


To apply the retain columns filter:

Numbered Headings
Select Retain Columns.

Image Modified

Select Add Filter.

Image Modified

Select Add.

Image Modified

The Retain Columns dialog opens.

Image Modified

Edit the parameters.



Source column (required)

Name of column to retain

Column name (required)

New name for retained column. If you are not renaming it, enter the same as Source Column name.

Default value

Value to apply if column value is null

Data type

Data type of the column values

Supported types:

  • string

  • double

  • long

  • timestamp

  • boolean (can be retained if already existing)

  • json

Optionally, do one of the following:

  • If you are finished with Filters, select Next.

  • If you want to add another filter, select Add and repeat the steps.