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!
Solved! Go to Solution.
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
Hi @Teresa3
Here is the simple solution, which will work for your sample and also huge dataset.
Output:
Many thanks
Shanker V
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
Hi @ShankerV,
Thank you very much!
Your solution is as simple as good!