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. 

[alexnajm]

Without seeing your data, we cannot help any further!

[binuacs]

@sblank1998 as @alexnajm mentioned, it would be easy to find the solution if you provide some data. also, if the join tool returns no records, it means there is no match found. See the below message, can you manually check both files and make sure those email ids are matching 

[Qiu · Accepted solution]

@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.

[sblank1998]

This worked. Thanks so much!

[Qiu]

Glad to be any help.