Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Vlookup using Alteryx

shells
6 - Meteoroid

Hello All,

 

Im still very new to Alteryx and I have read through several posts to try and solve mine but I must be doing something wrong.

I have a main file (Sample 2)  which has data such as the below:

EMPLOYEE
KU4596
SN1264
4782000
1264000

 

I want to add the "Title" against each of these if they exist by looking up a file which may have the data in either column 1 or 2. The second file (Sample1) looks something like this:

EMPLOYEE NUMBEREMPLOYEE SECONDARYTitle
KU45964596000Risk Manager
JH47824782000Safety Manager
NE12641264000Compliance Manager
JW12811281000Building Manager
SN12641264000CEO
HG75967596000Facilities Manager

 

I tried the join tool but I dont seem to be getting the right output.

What am I doing wrong? Any help would be great. 

Thanks in advance.

5 REPLIES 5
CharlieS
17 - Castor
17 - Castor

You'll need to make use of two Join tools (one for each field you'd like to join) and then combine the results with a Union tool. I've put together an example. One thing to note is that "Sample 1.xlsx" uses "1264000" twice, which confuses the results of the second join.

 

 

DavidP
17 - Castor
17 - Castor

The Employee field needs to be checked against 2 fields in your 2nd table, so you need 2 join tools and then union the output together, like this:

 

vlookup.png

smoskowitz
12 - Quasar

You could also use the find/replace tool and choose the option to append fields to record.

shells
6 - Meteoroid

Legend! Totally made my day. I was just using the one join tool to try and look up both columns.

shells
6 - Meteoroid

Thanks everyone for all your help

Labels