Loop through rows based on condition

charlie2 — Thu, 17 Jun 2021 07:56:00 GMT

Hi,

I have the following table with prices per customer and price category:

Customer	Price	Price Category
X	0,5	A
X	0,7	B
Y	0,5	A
Z	0,7	B

My goal is to keep the rows for each customer of price B, in case they exist, otherwise, keep price A. So price B prevails over price A. The desired result would then be to have the same table but without the first row:

Customer	Price	Price Category
X	0,7	B
Y	0,5	A
Z	0,7	B

Any suggestion on how to do so in the data editor?

Thanks in advance

topic Loop through rows based on condition in App Development

Loop through rows based on condition