Look if a field meets a certain criteria

Question

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.

aatalai · Answer

@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

cjaneczko · Answer

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.