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!
Solved! Go to 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.
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
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.
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
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
