Selecting rows based on finding several values

[AlteryxPrime666]

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!  

[grazitti_sapna · Accepted solution]

@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.

[ShankerV · Accepted solution]

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.

[ShankerV · Accepted solution]

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

[ShankerV]

Hi @AlteryxPrime666 

step 4:

step 5:

Step 6:

Output:

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

[AlteryxPrime666]

 Thanks a lot! This did the trick :) 

[ShankerV]

Hi @AlteryxPrime666 

Glad to know it worked. 

Happy to help!!!

Many thanks

Shanker V