Alteryx Preparation Data Cleansing Tool - gopalakrishnadondapati/alteryx GitHub Wiki

Alteryx ---> Preparation --> Data Cleansing Tool

Data Cleansing Tool perform the common data quality issues using the different parameters Specify the on which fields perform the operation.

1.Replace the NULL values with Blank("") if the field type is String

2.Replace the NULL values with 0 if field Type is Numeric.

*If want to replace the otherthan 0 and Blank use the Imputation Tool.

3.Remove the Unwanted characters

--Leading and trailing spaces

--Letters,Numbers,Punctuations

4.Modify the string case

uppercase,lowercase,Titlecase.

If want to perform the multiple operations on multiple fields use the "Multiple Data Cleansing Tool".

Data Cleansing Tool
Example Data Clensing Tool