12 Replies Latest reply: Feb 29, 2016 7:23 AM by Digvijay Singh RSS

    Want to show dedup scenerio or flag

    vir vir

      Hi,

       

      We have availalbe data like this :

       

       

      Booking ID      PersonID                  Email

      B01                 P01                           ABC@mail.com

      B02                 P02                          XYZ@mail.com

      B03                 P01                           ABC@MAIL.COM

      B04                 P01                          ABC@mail.com

      B05                  P02                        XYZ@mail.com

       

       

      Now as per scenerio , i dont to miss any data ....

       

      like   if i want unique email than my daa should like

       

      ABC@mail.com

      XYZ@mail.com

       

      But i want all the Booking ids....not like max of email and limited ids...

       

       

      same for person id ......if i can say i   want  unique person than in straight table i want all booking ids and email.......kindly suggest