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:
Data Cleansing tool can eliminate leading and trailing whitespace, remove nulls, clear numbers from a string entry, and with a simple check box automatically perform common data cleansing tasks. Let's review the options available within the...