Filter a data set based one of the columns .

AdithyaNaralasetty

For the data set below 

Company	employee	Plan	Status
ABC	1	A	Inactive
ABC	1	B	Active
ABC	2	A	Active
ABC	3	A	Inactive

I'm trying to  Filter the above data to return an active row when an employee exists in two plans (example  employee 1 ). For all other employees with single plan return the row irrespective of status. Is there a function that can filter this ? Thanks

Expected result

Company	employee	Plan	Status
ABC	1	B	Active
ABC	2	A	Active
ABC	3	A	Inactive

gabrielvilella

Hi, you need first to have a field identifying the method of how the records will be filtered by. See the workflow attached.

Conditional Filter.yxmd