Fuzzy String Matching between columns from different datasets

mpham3000

Hi All,

I try to match between two string columns from different datasets. The two columns do not contain exact values to match, only a certain part is matching like below. I want to match "origin_city" with "standardized_city_name", and if matching, replace values of "origin_name" to value of "standardized_city_name"

  dataset 1 : target data

 dataset 2: source data

I already tried "Find and Replace" tool but it was not working. Can someone help to address a way to tackle the problem? thank you.

fmvizcaino

Hi @mpham3000 ,

Here an example showing how to build your fuzzy match method to work.

Best,

Fernando Vizcaino

2020-06-25 Fuzzy String Matching between columns from different datasets.yxmd