"Search Within" a cell
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Preparation
- Regex
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)