Filtering Multiple rows

[sgaryali]

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.

[DataNath]

@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:

[binuacs · Accepted solution]

@sgaryali One way of doing this