Adding a column for country codes

[rkeenan125]

Hey all,

I'm having a brain fart. I'm needing to add a column containing country codes corresponding to the country in another column. 

On one input, I have sheet with two columns (one with countries, and the other with codes) and on the other input I have the worksheet with all the addresses and a column with the country where they reside. 

The main worksheet contains 15,000 lines and the other only has about 195 lines. When I try using the Join tool with the "Country" column being the key, my output drops to a little under 2,000 lines. 

I feel like I'm doing the Join incorrectly. 

Any input or recommendations would be greatly appreciated. Thank you!

[griffinwelsh · Accepted solution]

The join tool has multiple outputs that you can use to diagnose this. Compare the spelling for each country that appears in the L and R outputs of your join tool. Keep in mind that joins are case sensitive and check for leading/trailing spaces.

[Qiu]

Better to have some sample input and output so we can take a closer look.