Finding out the check

PNC97

Need to find out the employees had used vto or not I had attached the file with input and expected output 

sorting the ID(Asc) , date (Asc) and wkdhrs(desc) and After removing the duplicate.

The logic is if the AA has (Punch-In-vto) and (VTO-adjust punch in) are equal or (Punch-Out-vto) and (VTO-adjust punch out ) are equal need to get an output as used else not.

tried by using the unique tool but the output which I got has the AA used were 314 but the expected is to get the 309.

expecting a workflow solution 

Thanks in advance 🙂

Alteryx Test.xlsx

KilianL

Hi @PNC97 ,

I added your described logic in a workflow via a formula:

If [Punch-In-vto]=[VTO-adjust punch in] OR [Punch-Out-vto]=[VTO-adjust punch out]
Then 'used'
Else 'not'
Endif

As a result, I get a count of 316 for 'used'.

See workflow attached. (Move it into the folder where your test data is in)

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

Kind Regards,
Kilian
Solutions Engineer - Alteryx

PC2296 example.yxmd