Cleanse assets

Back Next

Replacing instances of dictionary values with valid values

You can configure a step to search for instances of values that appear in a dictionary and to replace each value with a corresponding valid value from the dictionary. You can use a dictionary when the list of values to replace is too long to enter as custom values. You might also use a dictionary when you will reuse the list of values in multiple cleanse steps.

On the

Configuration

tab of the cleanse asset, click

Add Step

Select the

Replace Values

option.

In the step properties pane, select

Replace Input Values with Dictionary Values

Select the dictionary to use in the step.

Click

Browse

to select the dictionary.

Select the valid column for the dictionary.

You can preview the dictionary contents in the Step Properties pane.

The valid column represents the preferred version of the values in the dictionary. The step searches for values that appear in other columns in the dictionary and replaces them with the corresponding values from the valid column.

Select or clear the option to perform a case-sensitive comparison between the dictionary data and the input data.

Verify the delimiter that the mapping will use to recognize discrete values in the input field. You can specify one or more delimiters.

The input delimiter determines how the mapping reads the input data when you select the Start or End option as the scope.

Set the scope for the search operation.

You can set the following options:

Anywhere. Replaces any instance of the value that occurs in the input field. Can replace multiple instances of the same value in a field.

Start. Replaces any instance of the value that is not preceded by another value in the input field.

End. Replaces any instance of the value that is not followed by another value in the input field.

Save the asset.

Step configuration

Download Guide

Watch

Comments

Cloud Data Quality Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Cleanse assets

Cleanse assets

Replacing instances of dictionary values with valid values

Replacing instances of dictionary values with valid values