Skip to main content Skip to complementary content

Cleanse processor

Replaces the content of records or fills records with a given value.

The Cleanse processor allows you to perform different operations to cleanse columns and records in a transformation flow.

Cleanse properties

Properties to configure to cleanse columns and records.

Configuration
Property Configuration

Function name

  • Fill cells with value: Select this function to fill all cells from this column with a given value.
  • Fill empty cells with text: Select this function to fill empty cells from this column with a given value.

Columns to process

Select the column or columns on which you want to apply a function in the list.

Information note

If you want to apply the same function to multiple columns at once, click Open dialog icon to open a tree view that allows you to select multiple columns.

Use with

  • Other column: Select this option to concatenate the column to process with another column.
  • Value: Select this option to concatenate the column to process with the custom value of your choice.

To rename the processor, click the EditEdit icon that is displayed when hovering over the default name of the processor.

To edit its description, click the EditEdit icon that is displayed when hovering over Description.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!