Need a solution

Hi,

I have a situation, have 2 dataset which need to be best matched. 1st data set contain name of the hotels and the 2nd dataset contain the brand. I need to match the correct brand to each hotel. How should i solve this? Tried appending the field but not working, Fuzzy match is giving wrong results, dataset is big.

eg:

Hotel Name

Hyatt Ahmedabad
Hyatt Regency Ahmedabad

Holiday Inn Washington

Holiday Inn Express Newyork

Brand Name

Holiday Inn

Holiday Inn Express

Hyatt Regency

Hyatt

Help

Accepted answers

binu_acs

@Data_enthusiast Can you try something like below?

Find_Replace_0812.yxmd

All comments

binu_acs

@Data_enthusiast have you tried find and replace the tool?

Find_Replace_0812.yxmd

Data_enthusiast

Hello, Thanks for your reply, this has partially worked but not working fully as the strings are compared with the exact keyword but if there is a slight change in the keyword, no results coming. Say if the hotel name starts with Radisson Blu xyz and the brand name in the list is Radisson Blu/Red, no results obtained. I have many instances of such cases where keyword is differing. A solution to this will be highly appreciated.

binu_acs

@Data_enthusiast Can you try something like below?

Find_Replace_0812.yxmd

Data_enthusiast

Wow! this has worked. highly appreciate your help! Cheers

Data_enthusiast

Attaching the sample data

Sample data.xlsx

binu_acs

@Data_enthusiast something you can do with the Fuzzy match but it is not giving me all the match, but you can play around

Parent_Hotel_Mapping_0816.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703