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?
