Hi,
Scenario: I have a list of Actions that are assigned to various users within the organization. We use those Actions to identify where the concentration of work is distributed. It has been requested by a specific organization to run the Action Owners against their list of employees. The result(s) would allow us to verify if people are properly assigned and Actions that need review.
I have a list of 50 employees and need to see if there is any mention of any employee in a field list of another set of data.
Using alphabets for easy reference:
Set A: [A,B,C,D,E,F...] (Call it 26 unique names)
Set B:[AB,A,1,2,4,6,Z,E,F]
The result would help me identify that AB, A, Z, E, F have matches to Set A. Let's assume the numeric numbers are other employees in other organizations.
I have found one solution similar to this but isn't the most sexy, scale-able, easy to comprehend for non-Alteryx users and that is: having my first column be the list I want to check for matches then appending to the first row the list of employees I'm checking - doing a multi-field formula which would count for any hits - summing and then filtering down.
Suggestions on other methods?
Thank you in advance!
