Filtering Multiple rows

Hi

I want to filter out rows for employee Name

Sagar

Mahesh

Because they have Peer In and and Peer out in Type Column

But I want to filter out all the rows for them for other type as well

How to do this? I am adding Sample Input and output both for reference

Thanks in advance.

Filter Sample file Input.xlsx

Filter Sample file Output.xlsx

Workflow

Accepted answers

@sgaryali One way of doing this

Filter_Peer_1031.yxmd

All comments

@sgaryali is this what you're looking for? We first apply a filter to find the 'offending' employees, before summarizing to just leave the name and then conducting a join based on that. We take the results from the L (Left) join anchor as these are results that haven't found a match and therefore don't belong to these employees:

If you want the inverse of this i.e. when you said filter out, you meant you wanted to isolate them, then just look at the J anchor:

Filter employees based on type.yxmd

@sgaryali One way of doing this

Filter_Peer_1031.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335