Using Fuzzy Match with multiple files

I have two files, file A contains the actual location name and file B contains the location name with but some extra data. For ex.

File 'A' data - "Manhattan"

File 'B' data - "00 - 00 - Manhattan"

File 'B' is recurring in nature and i get it daily and the data cannot be updated at source. Moreover, it may happen that tomorrow i get data in file 'B' as "0 - 0 Manhattan". So i cannot use Find Replace. If i am correct Fuzzy match can only look data in one file.

Is there a way to correct the name in File B using File A.

Output

Fuzzy Match

Join

Expression

Accepted answers

ImadZidan

Hello @Aryan1182114 ,

Thank you for the datasets. It helps a lot

Please have a look at the attached. I hope it looks better.

Any problem, shout back.

ReplaceText.yxmd

All comments

ImadZidan

Hello @Aryan1182114 ,

Have a look at this. It will give you an idea.

If you have a datasample, we can test .

Hope it is helpful

ReplaceText.yxmd

Aryan1182114

@ImadZidan

Thanks for the solution.

I tried this on my set, it worked for few but not for all.

I have attached below 2 files. File A contains the correct names and File B contains the typical error/ extra characters we may get.

As mentioned earlier that Find replace might not work as i am not sure what type of error/ extra character might pop up next... but it will be similar to what file A has.

File B.xlsx

File A.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703