Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Finding unique value

SCK
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

 

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

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