We have recently made changes to the interactive lessons to improve the experience when accessing from Safari. If you are still encountering issues with video playback, please email Community@Alteryx.com with details of the issues you are experiencing so we may investigate further.

Interactive Lessons

Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.

Also available in | Français | Português | Español | 日本語

VLookUps with Designer

Back to Lessons Feedback
ChristineB
Alteryx Alumni (Retired)
Created

 

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 inFrenchSpanishPortuguese, and Japanese