I'm trying to build a workflow that determines whether a user is a member of a category, based on whether they have all the items required for that category.
Each category has a list of required items, and each user has a list of items they own. A user is considered a member of a category only if they have every item that belongs to that category.
The goal:
I want to output which users are members of which categories. A user is a "member" of a category only if they have all items associated with that category.
Example:
Category-Item Mapping (Each Category–Item combination is unique, but the same item can belong to multiple categories)
Category | items |
A | 1 |
A | 2 |
A | 3 |
B | 3 |
B | 4 |
B | 5 |
User-Item Data (Each User–Item combination is unique, no duplicates)
| User | Item |
| UserA | 1 |
| UserA | 2 |
| UserA | 3 |
| UserA | 4 |
| UserA | 5 |
| UserB | 1 |
| UserB | 5 |
| UserC | 3 |
| UserC | 4 |
| UserC | 5 |
| UserD | 18 |
Expected Output:
User | MemberOf Category |
UserA | A |
UserA | B |
UserB | N/A (or empty... don't matter) |
UserC | B |
UserD | N/A (or empty... don't matter) |
I need help designing a workflow in Alteryx that can:
- Compare user items against category item sets
- Check if the user has all items from a category
- Return which users are members of which categories
