"Search Within" a cell

[D0Chapman]

Hi

I have an array data (roughly 80,000 lines) containing various filing info for various companies. It includes the company name and (as carriage broken entries in a cell) a list of subsidiary companies attached to/affiliated with each company. 

Historically, I'd run an if(error(search in excel, which returned "0" if a company name did not appear as a subsidiary attached to another company, or if it did a count of the number of instances where this occurred. A mock example is attached.

I'd like to replicate this in Alteryx. 

A bit of searching has suggested the RegEx function, but I don't think this would replicate the search throughout the entire "subsidiary name" column.

Thoughts?

[Yoshiro_Fujimori]

Hi @D0Chapman ,

I would use Fuzzy Match tool.

Workflow (see FuzzyMatch.yxmd)

Output

Fuzzy Match tool configuration

I am aware that "Poitiers & Co" is missing in my result.

You may want to split the names containing "new lines" to multiple rows, if that is acceptable.

Added a step to Split (see FuzzyMatch_Split.yxmd)

New Result

Now "Poitiers & Co" is matched.😉

I hope this can be of some help. Good luck.

[AdamR_AYX · Accepted solution]

 If they are all exact matches (as in your example) then I think you could do this without RegEx or Fuzzy Matching like so