12 Replies Latest reply: May 6, 2016 7:06 AM by Ruben Marin RSS

    Removing the duplicates

    reddy r
      Profile IDStatusCustId
      780INPROG100
      88INPROG200
      789INPROG200
      800INPROG300

      Here the above given table has duplicate customer ID(200).

      While loadind data from the table I would like to have the result like below by removing the duplicates completely.

       

       

       

      Output:
      Profile IDCustIdStatus
      780100Complt
      800300Cancel