Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHello, I am very new to Alteryx, so my suggestion might appear elementary for the veteran-users. From the standpoint of adoptation by less technical people (moving from Excel to Alteryx), would it be possible to take common scenarios of Fuzzy Matching and automate them?
For example, if you have 2 databases and you want to match and clean them up, you have to have close to 10 steps, with sorting, adding unique identifiers, joining, fuzzy matching, etc. Just look at your video named "Fuzzy Matching" or other videos for Tableau+Alteryx. They idea is basic. If you know most common use cases and you have already developed a methodology for how to solve these cases, why not have them as part of the tools library?
Also, when matching, for example universities, wouldn't it be easier if all those common, aka appearing many times, words were automatically suggested to be removed from the "match". Example: University A and Univeristy B are two different Universities, but they share the common word "University". While it's important that this word is there, it is not the reason to pair these two together. Maually going through and identifying and typing these common words is an extra step. It would be much easier to have a pop list of these common words and the count of records in which they appear, sorted by the count, and a check box to include or exclude the words.
Thank you,
Olga
Link to the Fuzzy Matching video. Check Minute 9:41.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.