Selecting rows based on finding several values

Hello, I have the following input (table on the left). I need to process the data so the workflow will check if there are more than one "employee" (column Employee Status) for Team ID each and then select it's supervisor. The wanted output is on the right. Anyone know how this could be done? Thanks a lot in advance!

Preparation

Accepted answers

grazitti_sapna

@AlteryxPrime666 , Please find below the workflow to achieve your output. Please note I have just used 3 fields as per needed. But same can be applied to your data set as well.

New Workflow5.yxmd

ShankerV

Hi @AlteryxPrime666

Please find the expected output.

Input: I have created the input as you have shared in the sample dataset

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV

Hi @AlteryxPrime666

Step 1: Input

step 2:

Step 3:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

All comments

grazitti_sapna

@AlteryxPrime666 , Please find below the workflow to achieve your output. Please note I have just used 3 fields as per needed. But same can be applied to your data set as well.

New Workflow5.yxmd

ShankerV

Hi @AlteryxPrime666

Please find the expected output.

Input: I have created the input as you have shared in the sample dataset

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

Christina_H

Here's a couple of quick ways of doing it. If your data is always in the same order with the supervisor first you can use just Summarize and Filter to get the result. Otherwise you need a few more to correctly identify the supervisor.