1 Reply Latest reply: Dec 13, 2015 12:16 PM by Massimo Grossi RSS

    Handling duplicate customers

    reddy r
      Profile IDStatus1Status2CustId
      780INPROGComplt100
      88INPROGCancel200
      789INPROGComplt200
      800INPROGCancel300

      The above table has  duplicate customer(200)  and two unique customers(100 & 300).

       

      For Duplicates customer the Status would be taken as Status1

      For Unique customers  the Status would be taken as Status2.

       

      Please help me to get the below mentioned result.

      Output:
      Profile IDCustIdStatus
      780100Complt
      88200INPROG
      789200INPROG
      800300Cancel