Applying Parsing and Formula Tools
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Course Introduction
Course Introduction
In this lesson, we introduce the case that we will examine in this course as well as the tools we'll use for our analysis.
Date and Time Basics
Date and Time Basics
In this lesson, we learn the specific way in which dates and times are interpreted and manipulated by Alteryx using the DateTime tool.
Applying Formulas to Multiple Fields
Applying Formulas to Multiple Fields
The Multi-Field Formula tool is typically used to manipulate data across the same row. Learn how to use the tool in this detailed lesson.
Using the Text to Columns Tool
Using the Text to Columns Tool
In this lesson, we learn how to use the Text to Columns tool to separate combined fields in Alteryx.
Parsing Data with the Formula Tool
Parsing Data with the Formula Tool
In this lesson, we learn some additional techniques of using the formula tool to separate text into recognizable components.
Using Conditional Functions
Using Conditional Functions
In this lesson, we learn how to use the formula tool to write conditional functions to manipulate and convert data.
Using the Switch Function
Using the Switch Function
In this lesson, we learn how to switch function and use it to further categorize the data.
Generating New Rows of Data
Generating New Rows of Data
In this lesson, we learn how to use the Multi-Row Formula tool to manipulate data across different rows. This lesson also introduces the Generate Rows tool.
Calculating Moving Averages
Calculating Moving Averages
This lesson builds on our previous work with the Multi-Row tool to create a moving average calculation.
Calculating Quarterly Revenue
Calculating Quarterly Revenue
In this lesson, we use the DateTimeYear and DateTimeMonth functions to split our date data into quarters, and aggregate revenue data accordingly.
Analyzing Market Share
Analyzing Market Share
In this lesson, we use the formula and filter tools to calculate the market share of each geographic sales area.
