Join Tool Outputting Zero Results

sblank1998

I am trying to compare an employee user listing and a termination report using employee emails as the unique identifier. When I run a VLOOKUP in excel, it produces 5 results of employee user emails that have been terminated. However, when I run it Alteryx, it produces 0 results. Does anyone know how I can fix this? 

- I removed null columns and rows, replaced nulls with blanks and zeros, and removed all leading or trailing whitespace for both files.

- I selected only the employee emails as the columns I wanted to join. 

Alteryx 3.png

Alteryx 1.png

Alteryx 2.png

Alteryx results.png

Qiu

@sblank1998 
Since you mentioned you can pick up 5 matching records with VLOOKUP function of Excel, so appears to me that maybe because the VLOOKUP is not case sensitive, while Join tool of Alteryx is.
Try to turn on the option of "Modify Case" in Cleansing tool for both data stream.

0604-sblank1998.yxmd