3 Replies Latest reply: Jun 28, 2014 6:20 AM by Abhishek Agarwal RSS

    Removing the similar rows based on the error in one row

    Abhishek Agarwal

      Hi Guys,


      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.


      Thanks in advance for your help!!!