Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Cleanse processor

Fills or replaces fields with a given value.

The Cleanse processor allows you to modify the content of your fields by using either the value of your choice, or a standardized value from another field.

Usage

The Cleanse processor requires one input flow and can generate only one output flow.

Properties

Properties to configure to cleanse fields and records.

Configuration
Property Configuration
Function name

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

  • Fill empty cells with values: Select this function to fill empty cells from this field with a given value.
Fields to process

Select the field or fields on which you want to apply a function in the list.
Use with

  • Other field: Select this option to concatenate the field to process with another field from the drop-down list.

  • Value: Select this option to concatenate the field to process with the custom value of your choice, set in the Value field.

To rename the processor or edit its description, point your mouse over the name or description to change in the Properties panel and click the Edit Edit icon.

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 – please let us know!

Leave your feedback here