This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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
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.
Fuzzy match requires the data to be matched to be in the same column. As you correctly researched, you will therefore have to combine the two files and this will result in everything matching to everything else.
I therefore added a condition after this match to exclude any fuzzy matches where the rowID is not the same (i.e. exclude cross-row matches).
I have not configured the fuzzy match so you will have to tweak these in order to get more accurate results as only two of the records are getting any sort of match at all for name, and one for phone number.