Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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):
| Name | Combination |
| User2 | 4b |
Solved! Go to Solution.
Hi @mustufa2019,
I think this is what you were trying to achieve?
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Hi @Jonathan-Sherman , i am having issues importing the file. i received the below error. Although i do currently have the latest version of Alteryx (2019 .4 X64). Would you know the reason?
Hi @Jonathan-Sherman this does work in a way but is not accurate I noticed. In the below workflow, we are matching based on the total jobs within a role. For example, there could be a job and user with the same number of roles but the roles (role names) might be different. In this case, we will get false positives.
