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!
