8v01d | (15) Alteryx Tutorial: Data Cleansing


8v01d (infinite void). I make art: code, sound/music/audio, visuals. I write code (sound, visuals, website development). I make gifs. I make YouTube videos. I create tutorials. I specifically concentrate in Music/Sound/Audio (Pure Data, Tidal Cycles, Sonic Pi, SuperCollider), Alteryx, Google Sheets/Excel, Visuals (Gifs, Graphic Design, Illustrator), Website Development (HTML, CSS, JavaScript). To learn or read more please click on about on the home page. Thanks.

December 14, 2020 at 11:21 pm

Data Cleansing

Performs basic data cleansing operations such as removing unwanted characters, cleaning whitespace, replacing null values, removing punctuation, removing numbers, and modifying capitalization.

To remove numbers, check the numbers box in the configuration window.

To remove punctuation, check the punctuation box in the configuration window.

To remove white space check leading and trailing whitespace.

To modify the case check modify case and then in the drop down select any of the following.

To remove nulls check the checkboxes under replace nulls. You can check either of them and they’ll give you different options. For this example, I will check both of them.

Posted in Alteryx Tutorial
Written by 8v01d
No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Subscribe via Email

    Enter your email address to subscribe to this website and receive notifications of new posts by email.