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 Input.xlsx multi.xlsx single.xlsx

How to Separate Employees with Single vs. Multiple PPNs

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

Input.xlsx

multi.xlsx

single.xlsx

Transformation

Accepted answers

binu_acs

@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

Employee_07022025.yxmd

All comments

binu_acs

@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

Employee_07022025.yxmd

Navyasree123

@binu_acsThanks 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.

AncientPandaman

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703