0 Replies Latest reply: Jul 4, 2016 12:20 PM by ARINDAM DUTTA RSS

    Creating replicating rolling dates

      hi everyone

      I have a script that create andload rolling dates.I want to create the same date three time and put a corresponding country adjacent to each of the three similar date .The script is given below can anyone help me with on how to make the reqired script



      LOAD Date($(rEndDate)-IterNo()+IterNo()) as Date,

      Date($(rStartDate)+IterNo()-1)as RollDate

      AutoGenerate 1 While $(rStartDate) + IterNo() -1 <= $(rEndDate); 

      NEXT i ;