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.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.
I have two lists with company names that I would like to match. The 'best' unique identifier would be the website, but I do not have a website entry for all companies. So for those without a website I would like to match via the the company names (different spellings, not all names incluced in both lists).
No more columns
CompanyName from List 1
Match score with list 2
CompanyName from List 2
Columns x-y from List 2
What I tried so far:
- Added both lists via data input
- Removed duplicates
- Added a column for source file in each list
- Added a union tool to combine the lists
- Added the fuzzy match tool: Merge, source file names as source ID field, companyName as record ID field, match style company name, ticked output match score & unmatched records -> did not work and also missing the match style for website as this should be my first match criterium