Vlookup in alteryx

[sudeshnasen]

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"

G	H	I	J (output required)
AMR	US	240	240
CAN	AMR	233	233
BRZ	BR	432	#NA
TRK	TR	123	#NA

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

[estherb47 · Accepted solution]

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 · Accepted solution]

Can we see your current workflow @sudeshnasen?

[jdunkerley79]

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

Something like:

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