Vlookup on Multiple Columns

[cohunter1990]

Hi I am new to Alteryx and I'm trying to do a Vlookup on multiple columns.

Any guidance would be appreciated.

FILE 1

Location Code	Location Description
0	DEFAULT
889010	AL
889020	AK
889030	AZ
889040	AR
889050	CA
889060	CO
889070	CT

FILE 2

PO Location	Location	po st	loc st
0	889010
889020	889020
0	889070
889040	889040
889050	889050
0	889060

Desired Output

PO Location	Location	po st	loc st
0	889010	DEFAULT	AL
889020	889020	AK	AK
0	889070	DEFAULT	CT
889040	889040	AR	AR
889050	889050	CA	CA
0	889060	DEFAULT	CO

[ChrisTX]

At the top of the main Alteryx screen, under the Join tab, try the Join Multiple tool.

Here's the tool mastery article:  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Join-Multiple/ta-p/124...

Chris

[Gumsmenezes]

Hi @cohunter1990, please see attached the worflow I created to help you.

I used two joins and there you go :)

[binuacs · Accepted solution]

@cohunter1990 One way of doing this

[cohunter1990]

The workflow did work but when I used it with my actual file that has more than 10,000 PO and Location codes, it only output like 1,300.

[binuacs]

@cohunter1990 It should output all the records. Can you connect your select tool output to a browser tool and check again ?

[cohunter1990]

This worked!!! Thank you!!!