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 CodeLocation Description0DEFAULT889010AL889020AK889030AZ889040AR889050CA889060CO889070CT FILE 2 PO LocationLocationpo stloc st0889010 889020889020 0889070 889040889040 889050889050 0889060 Desired Output PO LocationLocationpo stloc st0889010DEFAULTAL889020889020AKAK0889070DEFAULTCT889040889040ARAR889050889050CACA0889060DEFAULTCO

Vlookup on Multiple Columns

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

Any guidance would be appreciated.

FILE 1

FILE 2

Desired Output

Workflow

@cohunter1990 One way of doing this

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

Chris

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

I used two joins and there you go

@cohunter1990 One way of doing this

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.

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

This worked!!! Thank you!!!