prompts you to select an asset type. When you select Cleanse,
Data Quality
opens a new cleanse asset.
The asset displays a
Definition
tab, a
Configuration
tab, and a
Merge
tab. Use the Definition tab to define the name and the location of the asset. Use the Configuration tab to configure the steps that the mapping will apply to the input data. Use the Merge tab to create new fields from on two or more fields across the instances.
You can also open the Definition, Configuration, and Merge tabs when you open the asset from the Explore page.
To create a cleanse asset, click
New
Cleanse
.
On the
Definition
tab, enter a name for the cleanse asset.
Optionally, enter a description.
Select the location in which to save the cleanse asset.
Optionally, select a data quality dimension to represent the type of data quality issue that you want the asset to examine.
panel shows additional assets that are referenced by Data Quality assets to perform transformation tasks. When you create a new asset, there are no referenced assets.
Optionally, add a tag to the cleanse asset. You can search for assets with a common tag on the Explore page.
Select the Configuration tab.
Data Quality
displays the configuration workspace for the cleanse asset.
Data Quality
also displays a validation message to indicate that the step configuration is incomplete.
When you create a cleanse asset, the Instance panel in the
Configuration
view displays a single default cleanse instance. By default, the instance contains a single input field. The input field name is the name of the asset. Optionally, you can add input fields and modify the default input field name and instance name.
Optionally, add one or more cleanse instances. For information about how to add a cleanse instance to the asset, see
Adding a cleanse instance to the asset.
Add a step to each cleanse instance in the asset.
Select one of the following step types:
Convert Case
Remove Values
Remove Spaces
Replace Values
Configure the properties on the step to create an operation that the mapping can apply to the data.
Optionally, add one or more additional steps to each instance.
Configure the properties on each step that you add.
Optionally, configure a merge operation for two or more input fields. For information about configuring the fields to merge, see
Merging records.
Save the asset.
After you configure the cleanse asset, test the asset with sample data.