Multiple Selection to Join

IvanMtz88

Hello Community i hope you're doing well

My question is how can i join an information from a multiple selection let me explain better

I have this data base that has Country Codes

Code          Country

MX             Mexico

US             United States

BA              Bosnia and Herzegovina

So i need to join  the code to a datasource that comes with only the country but the situation is that the file sometimes comes with another variant of the name lets say

Country 

USA

Bosnia and Herzegovina

Bosnia-Herzegovina

but is the same country so do you know how i can make that join

Thank you so much in advance for your help

ChrisTX

Looks like the country list needs a little clean up.  You could try the Find Replace tool.

Or the Fuzzy Match tool.  Search the training videos for "fuzzy":  https://community.alteryx.com/t5/Videos/bd-p/live-training

Chris