Rows not joining even though they have a match

Question

I am trying to join two data sources to essentially complete an "index match" as if it were excel. In one data source, I am matching "Mgr_EMPLID" to "EMPLID" in the other data source. My end goal is to input a column with the manager's position title, which does not explicitly exist in either file. I just have to use the list of employee IDs and position titles to make a match.

Please help! 183 of 8544 rows aren't pulling a match when they should be.

Emil_Kos · Answer

Hi,

Use the data cleansing tool and make sure they are the data sources are consistent.

No spaces special characters. Maybe change everything to upper.

My advice would be focusing on one line that you know that should match.

Paste them into text input files and check if they are working. If you will focus on one detail you will shortly find the correct solution.