Free Trial

Alteryx Designer Desktop Discussions

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

Vlookup in alteryx

sudeshnasen
7 - Meteor

I'm trying to do a Vlookup in Alteryx but the problem is that the value that is being matched can be in either one of col G or col H. The values to be populated is in column I. 

 

My excel function looks like this: vlookup(A1,$G:$I,3,FALSE)

 

I'm trying to do this using join but I can only join on either G or H. If the data is in the other one, it is missed out. How to solve this?

 

EG: I'm looking for "AMR"

 

GHIJ (output required)
AMRUS240240
CANAMR233233
BRZBR432#NA
TRKTR123#NA

 

 

PS: hard-coding to look for AMR won't work because I've to look for 20-30 such strings like AMR

3 REPLIES 3
estherb47
15 - Aurora
15 - Aurora
Hello,

Try two different joins - one to G and one to H, and then union the results
from each J output together.

Let me know if that helps

Cheers!
Esther
--
Esther Bezborodko
*Senior Manager*
201.650.7314 | estherbezborodko@gmail.com
beautycounter.com/estherbezborodko

*Our mission is to get safe products in the hands of everyone.*
[image: Facebook]
Jonathan-Sherman
15 - Aurora
15 - Aurora

Can we see your current workflow @sudeshnasen?

jdunkerley79
ACE Emeritus
ACE Emeritus

I would so slightly differently to @estherb47  using a pair of Find-Replace tools

 

Something like:

jdunkerley79_0-1574076972482.png

 

Each tool does the "VLOOKUP" on one column adding a match

Then use a formula tool to make the required output and drop the extra columns

 

Quick sample attached

 

Labels
Top Solution Authors