Look if a field meets a certain criteria

[malcorr]

Hello, 

i have a dataset which is a list of all the entitlements each user has. 

in one column, i have the user id, and in the other one, the entitlements.

i need to check if all the users have the entitlement “aoro”. If they dont, then i want to display “check” or something like that. 

The problem is that the id gets repeated in every row. So, for the same id, the person can have several entitlements.

[cjaneczko]

One way would be to use the Unique Tool on ID to get a list of all of the ID's. Use another Tool on a separate flow to filter on "aoro". Then join the Unique list to the "aoro" path and look where there is no commonality between the two. Would either be on the L or R output anchor of the join. This will give all ID's that do not have "aoro" entitlements.

[aatalai]

@malcorr  Try this use the formula tool and create a new field with the following condition If contains([entitlement],“aoro”) then 1 else 0 endif Make sure it is a numerical data type. Then use the summarise tool and group by user if and max the newly generated field. now if it is 1 they have the aoro entitlement and if 0 they do not.

LEt me know if this helps