8v01d | Alteryx Tutorial

8v01d

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.

Category: Alteryx Tutorial
December 14, 2020 at 11:23 pm

Unique

Distinguishes whether a data record is unique or a duplicate 

Unique tool has two outputs. The U (for Unique) stream and the D (for Duplicate) stream

Posted in Alteryx Tutorial
Written by 8v01d
No Comments

December 14, 2020 at 11:22 pm

Select Records

Can be used to choose a precise subset of input records. 

Posted in Alteryx Tutorial
Written by 8v01d
No Comments

December 14, 2020 at 11:22 pm

Sample

Extracts a specified portion of the records in the data stream.

Posted in Alteryx Tutorial
Written by 8v01d
No Comments

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

December 14, 2020 at 11:20 pm

Auto Field

Sets the field type to the smallest possible size. Basically, auto changing the field type to the optimal type and size.

Posted in Alteryx Tutorial
Written by 8v01d
No Comments

  • Subscribe via Email

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