Find Replace Tool all possible matches

Question

This post got me most of the way there.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Use-Fuzzy-Match-to-search-possible-pairs-in-a-long-text/td-p/12289

Also thanks to jdunkerly79, I took his example and just added two small changes to illustrate my need.

My desired output, not the blah blah MNQ ABC company has two possible matches in Field1

TestField1AU - 1100010(150M) - PTH(PAHDDH) -EPL - ABC Company LLABCAU - 1100010(150M) - PTH(PAHDDH) -EPL - MNQ Company LLMNQAU - 1100010(150M) - PTH(PAHDDH) -EPL - TZK Company LLTZKus -blah blah - mnq companyMNQus - blah blah more more - mnq abc companyMNQus - blah blah more more - mnq abc companyABC

Actual output does not include the last row with the mnq abc company and the abc field1

I'm looking for this type of scenario as I'm trying to identify possible matches between a specific system's user ids and users in outlook address database.

Problem is users change names over the years and it is an entrenched system.  But I have all the SMTP addresses and have used other tools to create a list of the real names and every email id they have had over the years.

Now I want to search text within the emails over the years to see possible matches.  The final decision is

a) refining my process to get closer matches and

b) eyeballing it and reaching out to users.

Attached is the revised workflow as an example including an isolated Input Data tool that shows my desired output.  I just don't know how to get there.

All Combos.yxmd

fmvizcaino · Accepted Answer

Hi @DonMcCarty ,

You can use a combination of the append + filter tool to get the desired output. It first creates a cartesian join where you will have all the possible combinations and then using the contains functions, it selects all matched cases.

Best,

Fernando Vizcaino