How to Separate Employees with Single vs. Multiple PPNs

[Navyasree123]

Hey all,

I’m working on an Alteryx workflow where I need to categorize employee records based on the number of PPNs they have,

• If an employee has only one PPN, their entry should be categorized as "single Entries".
• If an employee has multiple PPNs, their entry should go to "Multi Entries".
• I need to implement this logic efficiently in Alteryx.

I have attched the expected outputs in the below

Thank you

[binuacs · Accepted solution]

@Navyasree123 your single.xlsx does not matching with the one I created, I am attaching the workflow based on my understanding, let me know if i am missing something

[Navyasree123]

@binuacsThanks for your solution! I followed the same approach. Do you think there's a more efficient way to handle this

[ntakeda]

@Navyasree123 

With the Only Unique tool, you can achieve this with only one tool.

[PangHC]

@binuacs i think it more to count distinct of PPN instead. 
because Employee have same PPN but code different.