Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Vlook up option

rojan
7 - Meteor

Hi,

 

I need a help to resolve VLOOKUP option for below file

 

sheet 1account no
ABC1
CBA2
ZUZ5

 

 

sheet 2 
ABC200
CBA500
ZUZ600

 

I want to get account no from sheet 1 and put it in sheet 2 based on name.

2 REPLIES 2
brandon_bunney
8 - Asteroid

Attached is a workflow with a join that takes account no from sheet 1 on the first text input and joins to sheet 2 on the 2nd text input.

vizAlter
12 - Quasar

Hi @rojan — Try this solution using a "Find Replace" tool:

 

vizAlter_0-1631824186699.png

Labels