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

Remove rows where field values are the same for unique identifiers

CD11
5 - 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!

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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

CD11
5 - Atom

Thank you - works perfectly!

Labels