Interactive Lessons

Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

VLookUps with Designer

Back to Lessons Feedback
Alteryx
Alteryx
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