Imagine a world where data cleansing had to be done manually. Countless hours would be spent fixing data to get the desired output. This would delay business decisions. Fortunately, with Alteryx less time can be spent cleaning your data and more time focused on analyzing your data. There is a very popular tool located in the Preparation tool palette called, you guessed it, Data Cleansing. It would only be fitting to start this section with the Data Cleansing tool.
In this section, we will continue to use the Florida Local Data for Better Health workflow from the Data Preparation section.
Step 1: Select the Data Cleansing tool from the Preparation tool palette and drag it onto the canvas. Connect the Data Cleansing tool to the Sort tool:
The Data Cleansing tool can eliminate leading and trailing whitespace, remove nulls, clear numbers...
