Alteryx Bootcamp | 25 Tools with Before & After Examples

In this video, we will work on the following configuration settings of the Input Data tool:

• Import only the list of sheet names

• Triple dot to change worksheet name

• Wildcard character (*)

• Data Preview = 100 records

In this video, we will use the Text Input tool to manually add data. We will also use the Select tool to change Field Type/Size.

In this video, we will work on the different aspects of the Browse tool such as:

• Data Profile information

• Copy to Clipboard

• New Window from Results Window

• Manually export (all or selected rows)

In this video, we will work on the following Output Options and Field Names of the Output Data tool:

• Overwrite Sheet (Drop)

• Take File/Table Name from Field

• Change File/Table Name

Please download the practice file for this section here.

In this video, we will look into the following settings of the Select tool:

• Data Type

• Rename Column & Sequence

• Keep/Discard columns for the next process

Create/update fields using one or more expressions to perform a variety of calculations and operations.

In this video, we will learn about the Formula tool. We will cover the following:

• Function button (fx)

• Conditional Function

• String Function

• Test Function

Create/update multiple fields using a single expression.

In this video, we will learn to apply function across multiple fields of data at once using Multi-Field Formula.

E.g. Dividing the columns in the dataset by 1,000.

- The Multi-Row Formula tool functions much like the normal Formula tool.

- It further adds the ability to reference multiple rows of data within one expression.

In this video, we will be learning about the following Multi Row Formula tool settings:

• Update Existing Field

• Create New Field

• Num Rows

• Group By

• Variables

• Functions and more...

In this video, we will learn to fix common data quality issues such as:

• Replacing Nulls

• Removing Unwanted Characters

• Modifying Case

It arranges the data values in alphanumeric order based on the values of the specified data fields.

In this video, we will be sorting records in ascending/descending order depending on the column's data type.

It splits the data into two streams (True/False) based on user-defined conditions.

In this video, we will learn the following configuration settings of the Filter tool:

• Select Basic/Custom Filter

• Custom Filter > Custom Expressions (fx)

- Similar to remove duplicate option in Excel.

- Helps to separate unique and duplicate data based on the selected columns.

In this video, we will learn to split data stream in 2 sets by using the following configuration setting of the Unique tool:

Find unique values from Column Names.

Limits the data stream to a specified number, percentage, or random set of rows.

In this video, we will learn the following configuration settings of the Sample tool:

1. Select Sample Type such as:

• First N rows

• Skip 1st N rows

• 1 of every N rows and more...

2. Group by column

Please download the practice file for this section here.

In this video, we will use the following configuration settings of the Find and Replace tool to standardizing data:

• Find Within Field

• Case Insensitive Find

• Replace Found Text With Value

In this video, we will understand the concept of the following JOIN Types:

• Left Outer Join

• Right Outer Join

• Full Outer Join

• Inner Join

• Left Anti Join

• Right Anti Join

Similar to an Excel's VLOOKUP and Power Query's Merge Query.

In this video, we will learn to add data columns horizontally. We will also learn about the Join tool configuration setting such as Join by Specific Fields.

Similar to Power Query's Append Query where columns are stacked vertically.

In this video, we will perform the following operations using the Union tool:

• Auto Config by Name

• Auto Config by Position

• Manually Configure Fields

Combines 2 data streams based on common fields/record position.

In this video, we will learn the following joining methods using JOIN and UNION tools:

• Left Outer

• Right Outer

• Full Outer

Please download the practice file for this section here.

- Similar to Excel's Text to Columns.

- Splits the text from one field into separate rows/columns.

In this video, we will learn to perform the following operations using Text to Columns tool:

• Columns to split

• Delimiters

• Split to columns

• Split to rows and more...

Transform date/time data to and from a variety of formats.

In this video, we will learn the following configuration settings of the DateTime tool:

• Convert Date/Time to String

• Convert String to Date/Time

• String field to convert

• Specify the new column name

Please download the practice file for this section here.

- It is similar to Pivoting data in Excel

- It pivots data (horizontal to vertical) for all selected fields

In this video, we will learn to use the Transpose tool to covert Cross Tab data structure to a Flat File format.

Similar to Pivoting data in Excel. It pivots data vertical to horizontal.

In this video, we will learn the following options that Cross Tab tool provides which are similar to Excel's Pivot Table:

• Group data by Values

• Change Column Headers

• Values for New Columns

• Method for Aggregating Values

It helps to group data, sum, count, or perform other calculations on the fields.

In this video, we will learn about the Summarize tool. We will see the following in working:

• Unique List with JUST GroupBy

• Aggregate (SUM, COUNT; CONCATENATE)

Please download the practice file for Dynamic Rename. Rest of the videos do not have any practice files.

It helps to organize the tools in a workflow.

In this video, we will learn the following settings of Container tool:

• Add to Container

• BG color & Transparency

• Minimize Container

• Disable Container and more

In this video, we will learn to access the One Tool Examples from:

• Tool Palette > Click on a tool (your choice) > Open Example

• Global Search > Search a tool name (your choice) > Click on the Example button

It helps to rename any or all columns in a data stream.

In this video, we will work with Rename Mode of the Dynamic Rename tool. We will cover the settings such as:

• Take Field Names from First Row of the Data

• Take Field Names from Right Input Metadata

• Take Field Names from Right Input Rows