Alteryx: Cleansing your data
Data Cleansing tool 
The Data Cleansing tool is used to fix any data quality issues in the dataset before continuing work with it. This is the tool to use to fix issues like white spaces or capitalization issues.
Things such as capitalization errors and whitespace errors are in the data seen below and these need to be correct before work is started on the workflow.
The Data Cleansing tool can be found under Preparation. Grab the tool and bring it onto the work canvas. As the Data Cleansing tool cpmes close to the Input Data tool, they will connect. 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, remove/replace null sets and remove unwanted characters.
Be sure to select the "Leading and Trailing Whitespace" 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.
Save this workflow for the next section.
