7 Replies Latest reply: Oct 8, 2016 3:45 AM by Sunny Talwar RSS

    how to split one record into multipal rows based on date?

    gaurav gopale

      hi all

       

      i have a table which has a unique id (ID) ,amount ,StartDate,EndDate.

       

      I have to check the StartDate and EndDate

      i.e  if a row contains ID=001 ,  StartDate = 01-jan-2016 and EndDate 01-08-2016

      IDStartDateEndDateAmount




      00101-Jan-201601-Mar-20161000

      I want to split that row by month

      i.e    

      IDStartDateEndDateAmount
      00101-Jan-201601-Feb-20161000
      00101-Feb-201601-Mar-20161000

       

       

      How i can split the the rows while loadling ? or is there any other way to do ?

      can anyone help me

       

       

       

      thanks in advance