Data Cleansing Tool

The Data Cleansing tool fixes common data quality issues using a variety of parameters.

Known limitation: dynamic workflows

The Data Cleansing tool is not dynamic. If used in a dynamic settings, such as a macro intended to work with newly generated field names, the tool will not interact with the fields, even if All options are selected. Consider replacing the Data Cleansing tool with a Multi-Field Formula Tool.

Known limitation: large number handling

Numbers with more than 15 digits need to be treated as strings, or they lose their precision. Set the field type to a string using the Select Tool.

Visit the Alteryx Community Tool Mastery series to learn even more about this and other tools.

Configure the tool

Use the following fields to determine how data quality issues are managed.

Select Columns to Cleanse

Select the columns (fields) you want to cleanse. Select from the following options:

All options, except for Replace Nulls with 0, apply to string data types. To specify different options for different fields, use multiple Data Cleansing tools in your workflow.