I’m building a workflow where the objective is to compare a customer list to a list of companies that is provided by a third party. We want to make sure that every customer appears on the third party’s list. There may be differences in the naming convention, which is why we typically run a fuzzy match. This takes a long time to perform in Excel, so we’re looking to get this into Alteryx.
I’ve provided examples of two workflows I’ve created and some sample data. The original customer file I’m working with has 3,240 entries. The original third party list has 6,770 entries. Within both files, the same company name may repeat, but it has different # identifiers. (The # identifiers have no correlation between the files, we don’t need to match based on them, we just want to keep all that original data in our output.)
When I run workflow number one, the output is 35,142 entries. (Doing a fuzzy match in Excel only results in the 3,240 entries.) There are a lot of duplicates because of the repeating company names/different # identifiers. I tried to remove these by adding a “unique” step in the second workflow, but am definitely not applying it in the correct manner. Also, even when a customer name matches a name from the third party, it continues to try to match it to other names (i.e. filter the output on customer name “University of Iowa” and see how it matches it against anything with “University” in the name, or “Cloos Electronic” matches with “Electronics”), which is why we’re getting so many entries in the results. We ignore the 100% matches. Typically, we only look at matches less than 80%, but the match %s coming out of Alteryx seem to be higher than the Excel match %s we get on the same data set, so I’m also concerned about false positives. I attached the output from the Excel match as reference.
I don’t have another Alteryx resource in my group, so I’m doing my best to teach myself via the trainings, etc. but am having difficulty – the output either has too many entries, or too few and is missing matches (or misses) that should be found. I know this is end user error, but I am struggling to make the solutions work and would appreciate any insight.
