Skip to main content
Data Manipulation

Applying Parsing and Formula Tools

With your data sourced and connected to your workflow, it’s time to learn how to parse, manipulate and perform calculations to extract the results you need. In this course, you will explore the various parsing and formula tools available in Alteryx.

Intermediate        11 Lessons        150 Minutes        CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

About This Course

When your data is flowing in from different sources, it’s unlikely to be arranged and formatted optimally. Luckily, Alteryx has a range of tools for parsing and arranging your data in a uniform way.

In this course you will explore the options for formatting your data, such as the DateTime tool. You’ll manipulate data using the text to columns tool. You’ll be introduced to the formula Tool, a powerful feature which vastly expands your options for parsing and applying conditional functions to your data.

By the end of this course, you will know how to transform your data into the correct form and format to be ready for advanced calculations. You will gain experience making said calculations using Alteryx’s powerful formula Tool.

GET STARTED

Learning Outcomes

  • Parse date data into the correct format
  • Convert text to columns
  • Parse text using formulas
  • Apply conditional functions
  • Calculate moving averages

Lessons

1. Course Introduction
2. Date and Time Basics
3. Applying Formulas to Multiple Fields
4. Using the Text to Columns Tool
5. Parsing Data with the Formula Tool
6. Using Conditional Functions

Read More

7. Using the Switch Function
8. Generating New Rows of Data
9. Calculating Moving Averages
10. Calculating Quarterly Revenue
11. Analyzing Market Share
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world