topic Re: Search names from a column to another and output the common name in Alteryx Designer Desktop Discussions

Search names from a column to another and output the common name

DE22 — Thu, 26 Feb 2026 13:59:59 GMT

Hello,

Could you, please help me? I want to check the AR_ Name column in the Client column and keep the common matching text (50-60% matching ). Moreover, if inside the AR_ Name clients have a similar name and if they do not match at all with the Client column, should return the AR_ Name. This should be applicable only for the AR_ name column not null/empty. Thanks a lot!

Re: Search names from a column to another and output the common name

alexnajm — Fri, 27 Feb 2026 00:20:31 GMT

If you are looking for a percent match, then Fuzzy Match is the tool for you! Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung

But I would say these are nowhere close to matching... so this will be a challenge

Re: Search names from a column to another and output the common name

jrlindem — Fri, 27 Feb 2026 15:00:25 GMT

I also took a look at this and played around with the Fuzzy Match, but couldn't get it to produce your expected results. I do think Fuzzy Match is the right method as @alexnajm pointed out, but your either going to need to configure your own matching rules or you're going to need to see what you can do to the data upstream to get it closer to aligning... -Jay