Fuzzy Match with ISO Country Code

[faiqz]

Hi,

I am trying to match my dataset (that contain correct and wrong ISO country code) with the correct dataset of ISO country code (let's call it country_lookup). However, it matches the wrong one. For example, if the country code from my dataset is MYS(which is correct), the fuzzy match will match it with country_lookup ISL. It should be matched with country MYS too. 

And there are also the incorrect ISO country code in my dataset which is CIN (I purposely wrote it CIN instead of CHN to see if it match or not) but the fuzzy match do not match that code with any thing. I'm afraid that I have wrong understanding in fuzzy match, thus that's why it match it with the wrong one. If any of you have any solution for this one, please drop it below. 

P/S: pls ignore the null value in the shipping_country field.

Thank you.

[SPetrie]

You have your match score set to 100, so only exact matches will be output.

The other problem you will run into is that CIN is a close match for 2 items in your lookup list. CHN and CAN.

How you want to deal with items that don't have a prefect match is up to you. I altered your flow and played with the match settings a bit to get you closer.

I have it flag CIN as no good match being found so you can decide what you want to do with those items.