Removing the similar rows based on the error in one row
I'm facing a difficulty while conditionally removing the data from the dataset. Please see the scenario below
Product ID Product Selling Price
ABC Grocery 12345
ABC Grocery-1 -
xyz non-veg food 23211
So this is a dummy dataset where we are fetching selling proce based on the product name. So in the second row, there is no selling price for "Grocery-1", therefore based on this condition I want to remove both the rows where product ID = ABC. But when I'm trying to do this, QV is only removing the row where where price is null.