Delete group based on Values included

[Teresa3]

Hi Community,

I have a set of data with groups (Employees) and I would like to delete the whole group if a specific Value is not included in the group. Please see the example below:

Condition: Delete Employee Group if Employee has no "Hypo" Pay Item -- here A has to be deleted.

Employee group	Pay Item
A	Add. S
A	BS
B	BS
B	Hypo
B	Add. S
C	Hypo
C	BS

Thanks for your help!

[ShankerV]

Hi @Teresa3 

The solution for this sample dataset it easy, do you need the same to work for a huge dataset also.

Many thanks

Shanker V

[ShankerV]

Hi @Teresa3 

Here is the simple solution, which will work for your sample and also huge dataset.

Output:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Teresa3 

Step 1: Input

Step 2: Filter tool

step 3:

Step 4; 

Output:

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[Teresa3]

Hi @ShankerV,

 Thank you very much! 

Your solution is as simple as good!