I am trying to create a match function within Alteryx to see if any users (table 2) match with a combination of roles (table 1). Basically, I want to flag/see all the users that have combination of roles from combinations 1-6. For example, you will see all the roles within combination 4b (bold in table 1) are inherited by User2 (bold in table 2). For such matches, i would like to see the users and the respective combination they have (see output example at the bottom). Is this possible within Alteryx? Any help would be highly appreciated!! I have also attached the below table in excel format (please see attachment)
Input File 1 - Table 1 Combination of Roles
Input File 2 - Table 2 Users and Roles (see attachment for complete list)
Output Example (showing all the matches):
