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 · Accepted solution]

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

[binuacs · Accepted solution]

@AdithyaNaralasetty 

[AdithyaNaralasetty]

Thank you for the solution . I observed in the last filter if I have to exclude more than one condition  in custom filter 

[status] != inactive or [status]!= terminated it does not seem to work. If I apply two different filter it gives me right data. any suggestion here. Thanks

[gabrielvilella]

Hi @AdithyaNaralasetty, using two negative conditions with an OR statement is not recommended as the logic can get twisted. I encourage you to use two separated filters or change you expression to something not using the negative condition.