Need a solution

[Data_enthusiast]

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

[binuacs]

@Data_enthusiast have you tried find and replace the tool?

[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. 

[binuacs · Accepted solution]

@Data_enthusiast Can you try something like below?

[Data_enthusiast]

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

[Data_enthusiast]

Attaching the sample data

[binuacs]

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