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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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!

Quasar

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