Hi All
I am fairly new to Alteryx and still getting my way round with the various powerful tools there are. I have a question please and will appreciate any help/guidelines. I want to match 2 columns at a row level to get a match score. So for example:
Row Hotel Name Info_HotelName HotelName Info_Telephone
1 HRS GDS BENELUX Benelux Hotel 49241400030 49-241400030
2 GREAT HOTELS MONTRA ODDER PARKHOTEL Odder Park Hotel - Odder (45) 86 54 47 44 86 54 47 44
3 GREAT HOTELS NORRE VISSING KRO Norre Vissing Kro (45) 8694 3716 8694 3716
4 SYNXIS EIGHT ACRES HOTEL Eight Acres Hotel (44) 1343 543077 (44) 1343 543077
For Row 1 : I want to fuzzy match Hotel Name to Info_HotelName and Hotel Telphone to Info_Telephone
For Row 2,3,4. : same
I have seen a lot of videos... and one option may be to split the files into Hotel Name, Hotel Telphone in one file and Info_HotelName and Info_Telephone in another file and combining the 2 files. But this (I think) will match the whole file. I am trying to match at a record level only.
I hope i have explained the problem.
Kind Regards
Naresh