Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Finding unique value

8 - Asteroid

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:

 

DataPlayer1 RolePlayer1Monitor RoleMonitorSubstitute RoleSubstitute
Name1OwnerClairePreparerMichaelOwnerClaire
Name2PreparerMichaelOwnerClaireManagerSean
Name3CheckerBenCheckerBenManagerSean
Name4ManagerSeanCheckerBenOwnerClaire

 

The duplicate values in the above dataset at each data level is, which is basically the output :

 

DataNameValue
Name1Player1 RoleClaire
Name1Substitute RoleClaire
Name3Player1 RoleBen
Name3Monitor RoleBen

 

 

17 - Castor

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:

atcodedog05_1-1609696454320.png

 

Hope this helps 🙂 Feel to ask if you have any questions

Labels