Delete group based on Values included

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!

Datasets

Data Investigation

Accepted answers

ShankerV

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

All comments

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

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335