9 Replies Latest reply: Jan 24, 2017 6:13 AM by sagar rahul RSS

    repeated data

    sagar rahul

      this is my table


      2314200255005000UP-15-AR-246208-Jan-201307-Jan-2014 2314200255003700



      and below table is as my output






      how should i get my output :


      when  REGISTRATION_NUM is repeated two times but with two different policy as in first table

      then is should give result as shown in 2nd table

      then while giving output we should check that date of loss (as shown in bold ie "28-Dec-2011")of old or previous policy should be less than of START_DATE(as shown in bold ie '08-Jan-2013') new policy but it should have same REGISTRATION_NUM .



      i want in script form not in load form