Vlookup using Alteryx

[shells]

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 NUMBER	EMPLOYEE SECONDARY	Title
KU4596	4596000	Risk Manager
JH4782	4782000	Safety Manager
NE1264	1264000	Compliance Manager
JW1281	1281000	Building Manager
SN1264	1264000	CEO
HG7596	7596000	Facilities 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.

[CharlieS]

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

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:

[smoskowitz]

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

[shells]

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

[shells]

Thanks everyone for all your help