Alteryx: Cleansing your data
Data Cleansing tool 
The Data Cleansing tool is used to fix any data quality issues in a dataset before continuing work with it. This is the tool to use to fix issues like white spaces or capitalization issues.The Data Cleansing tool can be found under Preparation. Grab the tool and bring it onto the work canvas. As the Data Cleansing tool is brought close to the Input Data tool, a connection will be made. If this doesn't happen, click on the output anchor and drag it toward the input anchor on the Data Cleansing tool.
Once the connection is made, the Configuration pane will show a dialog box where fields can be selected to be cleansed.
Select "Leading and Trailing Whitespace", then deselect the 2 "Replace Nulls" selections. Select the "Modify Case" option and select "Title Case" from the pull-down menu. Then click on the Run button.
All white spaces should be removed from the data and all text should be in Title case.
Unlike the Browse tool, the Data Cleansing tool has an output anchor -- This tool can be connected to another tool in the workflow.
Save this workflow for the next section.
