6 Replies Latest reply: Sep 23, 2013 8:53 AM by Celambarasan Adhimulam RSS

    Replacing Values

    Thomas Skariah

      Hi All,

      Can anyone suggest how i can achieve the following scenario in which there are three columns Ref,SubDate and Amount.

      (Please find the attached screen shot). Here there are Ref 300 & 300A (300 with suffix A) I have to replace the SubDate of 300A with that of Subdate of 300 and then have to  exlcude the entire record of ref 300 from the table.Similarly Subdate of ref 600B should be replaced with 600 and have to exclude both 600 and 600A from the table..This logic should should be applicable to  all Ref with suffix (A or B).

      Thanks in advance.

      Regards,

      Tom