In this video, we cover cleansing and parsing our data. In most data, there are nulls, blanks, and other characters in columns that we do not want. These cause longer-term issues in our data when we are trying to further analyze them – for example, when totaling columns with null values, you will receive errors. We can use a few tools in Alteryx to quickly and simply clean up our data!

Step 1: You can download the data set used in the video here: Netflix Data.

Step 2: Open Alteryx Designer. (if you don’t have Alteryx installed, download the 30 day free trial here.)

Step 3: Begin the video below: