Cleanse assets

Back Next

Updating the character case of the input data

You can configure a step to change the character case in a data field.

On the

Configuration

tab of the cleanse asset, click

Add Step

Select the

Convert Case

option.

In the step properties pane, select one of the following casing styles:

Upper Case

Lower Case

Toggle Case

Sentence Case

Title Case

If you select the Lower Case, Toggle Case, Sentence Case, or Title Case option, specify one or more delimiters for the input data. Optionally, select one or more dictionaries to apply to the input data.

If you select a dictionary, select a valid column for the dictionary. In addition to converting the character case, the asset replaces any value in a non-valid dictionary column with the corresponding value in the valid column.

Optionally, select or clear the option to leave uppercase words unchanged.

Save the asset.

Step configuration

Download Guide

Watch

Comments

Cloud Data Quality Homepage