community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Remove rows where field values are the same for unique identifiers

Highlighted
Atom

I am busy cleaning timesheet data and would like to remove those people that do not fill theirs in accurately and submit the same amount of hours each day (person A in table below).  Is there a way I can add in a rule to this effect? i.e. For each individual with the same name, if hours variable is constant remove these observations - data for person A would be deleted and data for person B retained

 

PersonHours worked per day
A12
A12
A12
B9
B15
B13

 

 

Thank you!

Aurora

Hi @CD11

 

If you perform countdistinct of the values grouped by person, you'll then be able to filter out those below some threshold

 

 solution.png

Note that I added a person C to your input data to have a bit more variety.

 

Dan

Atom

Thank you - works perfectly!

Labels