VLookUps with Designer
Article Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
ChristineB
Alteryx Alumni (Retired)
01-08-2024
08:29 AM
Created
09-08-2017
12:21 PM
on - edited on by
AYXAcademy
Sign In
Lesson Objective: Learn to leverage a LookUp table to find an unknown value and associate that value to an existing dataset.
Estimated Time: ~12 Minutes
Description:
- Understand the concept of a VLookUp function and the equivalent process in Designer using the Find Replace tool
- Match values in a VLookUp table to values in an existing dataset
- Replace values in or append associated values to an existing dataset from a VLookUp table
- Explore the differences between using a Find Replace tool or a Join tool to perform a VLookUp
- Test your knowledge with a quiz
Recommended Follow-Up: Joining Data, Sorting Data
This lesson is also available in: French, Spanish, Portuguese, and Japanese
Labels: