0 Replies Latest reply: Oct 28, 2013 12:07 PM by Shreyas Ram R RSS

    How to avoid duplicates in record filter?

    Shreyas Ram R

      Hi Friends,

       

      Please advise on the below issue:

       

      We have products carried out in 2 different groups ex:group A and group B,but it is not mandatory that all the products should be present in both groups.

      When a product is carried in both the groups,then we are seeing duplicate products and our requirement is if a product is present in both groups,we nee to get the remove the consider the product from group A.

       

      Please help us out.

       

      Current we are using the following record filter which can definitely yield duplicates when a product is carried out in both groups.Please advise as how we can alter the record filter or any other approach to fix this issue.

       

      AND(Record_Type:Wine,OR(group_name:A,group_name:B))

       

      Regards

      Shreyas