Course
|
Alteryx

Finding and Replacing Data

Through this course, analysts will learn more advanced techniques for parsing and manipulating data through Alteryx. Analysts are introduced to the concepts of Fuzzy Matching and Regular Expressions through a series of lessons.
2 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Find and replace data using reference data
Match ambiguous text entries (e.g. ABC & ABC Inc)
Use RegEx to perform advanced text parsing
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Alteryx

Finding and Replacing Data

Through this course, analysts will learn more advanced techniques for parsing and manipulating data through Alteryx. Analysts are introduced to the concepts of Fuzzy Matching and Regular Expressions through a series of lessons.
2 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Find and replace data using reference data
Match ambiguous text entries (e.g. ABC & ABC Inc)
Use RegEx to perform advanced text parsing
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

11 Lessons
Finding and Replacing Data
7 MINS
LESSON
Finding and Replacing Data
Exercise

Learn how to use the Unique tool to filter out duplicate records, and how the Find and Replace tool can transform specific fields directly.

Preparing Data for a Fuzzy Match
5 MINS
LESSON
Preparing Data for a Fuzzy Match
Exercise

In this lesson, we learn how to prepare our data set properly for ease-of-use in conjunction with the Fuzzy Match tool.

Configuring the Fuzzy Match Tool
7 MINS
LESSON
Configuring the Fuzzy Match Tool
Exercise

This lesson offers an introduction to the Fuzzy Match tool, focusing on calibration and configuration.

Running our First Fuzzy Match
6 MINS
LESSON
Running our First Fuzzy Match
Exercise

This lesson shows the Fuzzy Match in action and teaches us how to iterate on the initial results.

Refining the Fuzzy Match
7 MINS
LESSON
Refining the Fuzzy Match
Exercise

In this lesson, we learn how to combine the fuzzy match process with the Formula tool for more accurate matching.

Finalizing the Fuzzy Match
6 MINS
LESSON
Finalizing the Fuzzy Match
Exercise

In this lesson, we finalize our match by replacing the Match Key with a technique utilizing the Find and Replace tool.

Fuzzy Match Review
5 MINS
LESSON
Fuzzy Match Review
Exercise

This lesson contains a detailed review of the previous five lessons on the complex topic of fuzzy matching in Alteryx.

Introduction to Regular Expressions
3 MINS
LESSON
Introduction to Regular Expressions
Exercise

This introductory lesson explains in detail what a Regular Expression does the fundamental concepts behind this very clever tool.

Dissecting a Regular Expression
3 MINS
LESSON
Dissecting a Regular Expression
Exercise

In this lesson we dissect a regular expression that parses a UK postal code.

Using the RegEx Tool
4 MINS
LESSON
Using the RegEx Tool
Exercise

In this lesson, we learn how to use the RegEx tool and apply it to a common data manipulation task.

Other RegEx Outputs
5 MINS
LESSON
Other RegEx Outputs
Exercise

Learn about the other output methods available in the RegEx tool.

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo