Hi all. I need help in finding the duplicate values on the basis of different roles a person has been assigned at each data level, in the below given data stream. Please help:
Input:
Data | Player1 Role | Player1 | Monitor Role | Monitor | Substitute Role | Substitute |
Name1 | Owner | Claire | Preparer | Michael | Owner | Claire |
Name2 | Preparer | Michael | Owner | Claire | Manager | Sean |
Name3 | Checker | Ben | Checker | Ben | Manager | Sean |
Name4 | Manager | Sean | Checker | Ben | Owner | Claire |
The duplicate values in the above dataset at each data level is, which is basically the output :
Data | Name | Value |
Name1 | Player1 Role | Claire |
Name1 | Substitute Role | Claire |
Name3 | Player1 Role | Ben |
Name3 | Monitor Role | Ben |
Solved! Go to Solution.
Hi @SCK
Here is how you can do it.
1.Transpose so that all names comes in a single column.
2. Use summarize to find the count of occurrence for each name
3. Keep only the ones which occur more than once
4. Join it back to find all its occurrence
5. Filter out Owen and Checker
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions