Filter out all rows if one has an error

[Travis_Ratliff]

Hi,

I am looking for a way to filter out all rows for one counterparty if one of its rows has an error. Using the example data all of Mcdonalds and Burger Kings rows would be filtered out because at least one row has an error, but Subways would not be filtered out.

Example Data:

Counterparty	Start Date	Price	Error
McDonalds	06/02/2024	35.87	N
McDonalds	06/10/2024	12.45	Y
McDonalds	06/15/2024	16.78	N
McDonalds	06/22/2024	92.8	Y
Burger King	06/05/2024	45.76	Y
Burger King	06/08/2024	23.77	N
Burger King	06/28/2024	23.32	N
Subway	06/02/2024	67.89	N
Subway	06/12/2024	10.01	N

[cjaneczko]

You can use a filter and then join the data back to the original set and just take the left side of the join.