Data Filter

Question

Hello Team,

I'm a new user to Alteryx, i need help in resolving a issue in the workflow. I've attached the input and output files for your reference. I have 4 columns in the file. Emp ID, Work/Break Category , Start (Shift Start) and End (Shift End).  Work/Break category is segregated into 3 types , Work , Break and Check-in. My requirement is, whenever i have this "Check-in" row for an employee, i want the "Work" row to be deleted and it should be replaced by "Check-in" start and end time.

Can you please help me in finding solution for this ?

Thanks in Advance!
Regards,

Ashwini P

Test Input.xlsx

Test Output.xlsx

Qiu · Answer

@Padashwi 
lets try something different.

1115-Padashwi.yxmd

AngelosPachis · Answer

Hi @Padashwi ,

You will need a filter tool to first find the employees that have checked in and then another one to filter out those that have checked in but also have a "work" record in the [Break/Work] field

Hope that helps,

Angelos

example.yxmd