0 Replies Latest reply: May 11, 2016 10:37 AM by Goutham Kandukuri RSS

    Creating New Date Records in Edit Script when Loading

    Goutham Kandukuri

      HI,

      i have a data set as below

       

      Id           Date               count

      1            2/10/16               2

      2             2/1/16                1

      3            5/6/16                 4

       

       

      I would like my result set as below

      Id           Date               count               Week Day(No Required)

      1            2/10/16               1

      1            2/11/16               1

      2            2/01/16               1   

      3            5/06/16               1                    Friday    

      3            5/09/16               1                    Monday   

      3            5/10/16               1                    Tuesday   

      3            5/11/16               1                    Wednesday


      Note: If the day of the week is Saturday or Sunday in has to skip date and select the next date. Based on the count the records should be created by increment(or adding a new record for same ID but using different date) one day(if it is Sunday or Saturday please pick following Monday as shown in example of ID 3)


      Can some one please advise.


      Thank You