Alteryx Designer Discussions

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

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