Skip to main content

Data cleansing properties

Properties to configure to cleanse fields and records.

Configuration
Property Configuration
Function name
  • Fill cells with value: Select this function to fill 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.
Fields to process Select the field or fields on which you want to apply a function in the list.
Information noteTip: If you want to apply the same function to multiple fields at once, click the Open dialog icon to open a tree view that allows you to select multiple fields.
Use with
  • Other column: select this option in the list to concatenate the field to process with another field.
  • Value: select this option in the list to concatenate the field to process with the custom value of your choice.
Info

Property

Configuration
Description (optional)

Enter a description for the processor.

To rename the processor, click the Rename Rename icon next to the default name of the processor.

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!

Leave your feedback here